Registered aircraft · 16,295

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.

N15FSHappytails Aviation LLC · Fort Collins, COBuilt 1981 · S/N 34-8133046 N15GHCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11388 N15KALighthouse Air LLC · Hobe Sound, FLBuilt 1979 · S/N BB-457 N15KDJohn W Sumrada LLC · Johnstown, PABuilt 2012 · S/N 2159 N15KMKansas Bryan T · Austin, TXBuilt 2021 · S/N 2776 N15LHInternational Air Services Inc Trustee · Carson City, NVBuilt 2018 · S/N 4715 N15RXLingo Aviation LLC · Cincinnati, OHBuilt 2004 · S/N 1164 N15SASkytrain LLC · Markle, INBuilt 2015 · S/N 4697599 N15SUSouthern Utah University · Cedar City, UTBuilt 2017 · S/N 2361 N15VECajunodysea Outfitters LLC · Madison, MSBuilt 2013 · S/N 3954 N15XJSt Express LLC · El Segundo, CABuilt 2022 · S/N 4636796 N1601SRussell Bryan E · Joshua, TXS/N 28-7790057 N1604CHodgens Craig · Edmond, OKBuilt 2006 · S/N 41697 N160CPN160cp LLC · Kalispell, MTBuilt 2006 · S/N 1751 N160EUSkyfusion II LLC · Atlanta, GAFirst renewal noticeBuilt 2003 · S/N 0759 N160MCHaiasi LLC · Wilmington, DEBuilt 2010 · S/N 411160 N160PGYoung Jared Lee · Fitzgerald, GABuilt 2008 · S/N 2995 N160PTPilot Training Center LLC · Miami, FLBuilt 1978 · S/N 44-7995161 N160SFTriumph Aviation LLC · Gaylord, MIBuilt 1975 · S/N BB-32 N160SRSarl Cirrus Marine Inc Trustee · Cheyenne, WYBuilt 2006 · S/N 2161 N160THolmberg Michael G · Hinckley, OHBuilt 1978 · S/N 28-7816373 N161AWAir Ward Inc · Columbia, CABuilt 1979 · S/N 28-8016078 N161BGWilson James R · Midlothian, VABuilt 1978 · S/N 287816527 N161DERegistered aircraftBuilt 1977 · S/N 28-7816295 N161JKCenter Point Aviation LLC · Pensacola, FLBuilt 2007 · S/N 2462 N161KMParis Air Inc · Vero Beach, FLBuilt 1977 · S/N 28-7716136 N161KTHill Jeremy A · Carmel Valley, CABuilt 2001 · S/N 1144 N161MABarnes Gordon R · Manalapan, NJBuilt 2000 · S/N 3257161 N161MBKerf 25 Corp · Wilmington, DEBuilt 1982 · S/N 28-8216163 N161MCHamilton Clayton S · Carrizo Springs, TXBuilt 2008 · S/N 411020 N161PTPilot Training Center LLC · Miami, FLBuilt 1989 · S/N 2841156 N161RPCrucial LLC · Kalispell, MTBuilt 1982 · S/N 32R-8213049 N161SMMorcom Aviation Services Inc DBA · Everett, WABuilt 1979 · S/N 28-7916508 N161SRMcfc Inc · Hood River, ORBuilt 2006 · S/N 2120 N161TFAirmart Inc · Lexington, KYBuilt 2022 · S/N 2881549 N1622PBaker Kenneth C · Brenham, TXBuilt 1992 · S/N 3213040 N1625CK&C Technologies LLC · Belleville, WIBuilt 2003 · S/N 0584 N1627HCirrus Services Inc · Fargo, NDBuilt 1977 · S/N 28-7716028 N1628HWarrior N1628h LLC · Huntsville, ALBuilt 1977 · S/N 28-7716029 N162AKAtlas N162ak LLC · Coral Springs, FLBuilt 2024 · S/N 9975 N162AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010078 N162CAWdf Montana LLC · Kalispell, MTBuilt 2007 · S/N 41772 N162CDDudley Joseph · Huffman, TXS/N 1066 N162FRFlying Restaurants LLC · Minot, NDBuilt 1993 · S/N 3448033 N162GLBoulder Aviation Partners LLC · Boulder, COBuilt 2012 · S/N 40.1162 N162LHFarmingdale State College · Farmingdale, NYBuilt 2010 · S/N 2842361 N162PCBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2018 · S/N 4496429 N162SR3 Brothers Plaza LLC · Nice, CABuilt 2006 · S/N 2088 N162STState Of Michigan · Lansing, MIBuilt 1978 · S/N LW-300 N1630WN O Good LLC · Wade, NCBuilt 2011 · S/N 4636508

Back to AD 2008-06-28 R1