Skip to content

AD 2008-06-28 R1

Registered aircraft · 16,280

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2008-06-28-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2008-06-28-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2008-06-28-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2008-06-28-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2008-06-28-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2008-06-28-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N75ZMC & S Aviation · Roswell, GABuilt 2004 · S/N 1045 N7602JGarrison Rodney Lynn · Atlanta, TXS/N 28R-30994 N7603JMcclain Thomas J · Toledo, OHBuilt 1968 · S/N 28R-30995 N7606JLiburd Edison V · Austell, GABuilt 1968 · S/N 28R-30920 N7607JMoser Robert W · Flower Mound, TXBuilt 1968 · S/N 28R-30936 N7608JGevry Ronald Joseph Jr · Alpharetta, GABuilt 1968 · S/N 28R-30999 N7609JMcmaster William Timothy · Hanford, CABuilt 1968 · S/N 28R-31001 N760BLAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2008 · S/N 4692012 N760C2nd Amendment Wholesale Inc · Grand Forks, NDBuilt 2008 · S/N 3257488 N760CDInternational Air Services Inc Trustee · Carson City, NVBuilt 2001 · S/N 0084 N760DSPeterson James Brian Trustee · Rch Palos Vrd, CABuilt 2007 · S/N 40.760 N760MASandpiper Air LLC · Elizabeth City, NCBuilt 2000 · S/N 3246160 N760PHopper Marvin · Farmerville, LABuilt 2004 · S/N 0988 N760UOhio University · Albany, OHBuilt 2005 · S/N 2842231 N760WParagon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020181 N7610JDelci Dino J · Tempe, AZBuilt 1968 · S/N 28R-31002 N7610UOhio University · Albany, OHBuilt 2025 · S/N 10549 N7612JSpeer Aviation LLC · Live Oak, FLBuilt 1968 · S/N 28R-30801 N7614JN7614j LLC · Berkeley Heights, NJBuilt 1968 · S/N 28R-31006 N7615JAll American Aviation Services Inc · Fayetteville, NCBuilt 1968 · S/N 28R-31008 N7616JThigpen Kevin · Jacksonville, FLBuilt 1968 · S/N 28R-31009 N7617JMilner Quinn D · Carbondale, ILBuilt 1968 · S/N 28R-31010 N7619FAinsworth Cavin · Fort Towson, OKBuilt 1976 · S/N 28-7790194 N761CTudo Bem Aviation LLC · Austin, TXS/N 0429 N761CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881738 N761CCHesston College Aviation · Hesston, KSBuilt 1976 · S/N 28-7690288 N761RBBastin Robet J · Cadiz, KYBuilt 1999 · S/N 3257107 N7620FRed 5 LLC · Kalispell, MTFirst renewal noticeBuilt 1976 · S/N 28-7790195 N7620UOhio University · Albany, OHBuilt 2025 · S/N 10550 N7622JSkylink Aviation Inc · Florissant, MOBuilt 1968 · S/N 28R-31017 N7623JWhite Jeffrey M · Carlsbad, CAS/N 28R-31018 N7624JBriggano LLC · Mount Pleasant, SCBuilt 1969 · S/N 28R-31102 N7625JHuebscher Attila · Flemington, NJBuilt 1968 · S/N 28R-31020 N7629FEagle Archer Pilots LLC · Indianapolis, INS/N 28-7790198 N7629JWatson Tony A · Rydal, GABuilt 1969 · S/N 28R-31024 N762ARMuller Consulting LLC · Leesburg, VABuilt 2018 · S/N 4676 N762CRRadio Net Corp · Camarillo, CABuilt 2007 · S/N 2870 N762CSWilliams James K Trustee · Yorba Linda, CAS/N 411111 N762HRAtlantic Outdoor Products LLC · Daniel Island, SCBuilt 2025 · S/N 10890 N762JBF/N Aviation LLC · Fort Lauderdale, FLBuilt 2006 · S/N 1735 N762NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 28010019 N762SRHenri Duval Ltd LLC · Wilmington, DEBuilt 2007 · S/N 2882 N762SSShetter Steven P · Chambersburg, PABuilt 1978 · S/N 28-7816537 N762TCCirrus Holdings LLC · Jordan, MNBuilt 2004 · S/N 1035 N762VARomeo Holdings LLC · Castle Pines, COBuilt 2021 · S/N 4636785 N7630UOhio University · Albany, OHBuilt 2025 · S/N 10552 N7634JSullivan Wade M · Mukilteo, WABuilt 1968 · S/N 28R-31030 N7635JBecker Riley · Transylvania, LABuilt 1969 · S/N 28R-31032 N7637F37 Foxtrot LLC · Mesa, AZBuilt 1976 · S/N 28-7790200 N7637JMartin Kevin H · Selbyville, DEBuilt 1968 · S/N 28R-31036

Back to AD 2008-06-28 R1