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.

N7734AArnold Dean C · Chapel Hill, NCBuilt 2011 · S/N 4692162 N7734CAstillero Ricardo · Northfield, NJS/N 28-7690079 N77350Bottom Line Technologies Inc · Columbia, MDBuilt 2003 · S/N 42013 N773ABCirrus Aviators LLC · Leesburg, VABuilt 2022 · S/N 5146 N773BBMinnesota Made Hockey Inc · Edina, MNBuilt 2007 · S/N 2425 N773CDMississippi Pepin Flyers LLC · Hager City, WIBuilt 2005 · S/N 1362 N773CVRengel & Co Architects Inc · Tustin, CABuilt 2018 · S/N 4644 N773DCFlying Rose LLC · Sparks, NVBuilt 2006 · S/N 1989 N773DVDuet Ventures LLC · Isle Of Palms, SCBuilt 2020 · S/N 4947 N773GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881221 N773JSRjb Aviation LLC · Newark, DEBuilt 1989 · S/N 4622073 N773MEConcord Flying Club LLC · Concord, NCBuilt 2015 · S/N 4636684 N773NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881038 N773PDLria Leasing LLC · Yakima, WABuilt 2023 · S/N 4636833 N773SRTiger Eye 2004 LLC · Montauk, NYBuilt 2007 · S/N 2773 N773TMSouthern Mooney Inc · Wilmington, DEBuilt 2012 · S/N 3449463 N773TVArtisan Consulting LLC · Alexandria, VABuilt 2025 · S/N 10734 N773WAEquipment Asset Management Corp · Huntington, TXBuilt 2020 · S/N 4636773 N77400Pettit Brian · Wshngtn Ct Hs, OHBuilt 2005 · S/N 4697206 N7740UPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020279 N7742GEmmons Michael R · Temple, TXBuilt 1984 · S/N 34-8433047 N7743ECol4hms LLC · Erie, COBuilt 2006 · S/N 41665 N77477International Air Services Inc Trustee · Carson City, NVS/N BT-10 N774BWZone Five LLC · Saint Petersburg, FLBuilt 2008 · S/N 411070 N774CHigear Aviation LLC · O Fallon, MOBuilt 2003 · S/N 1282 N774CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881763 N774CDValiair Limited Co Trustee · Casper, WYBuilt 2003 · S/N 0786 N774DMSn Holdings LLC · Des Moines, IABuilt 2020 · S/N 4636774 N774EBBruce Erik · Yreka, CABuilt 2022 · S/N 8926 N774FSHilty Kenneth C · Greensboro, NCBuilt 2000 · S/N 3257192 N774LLLedet Corp · Houma, LABuilt 2003 · S/N 3246213 N774NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881042 N774PTN774pt Inc Trustee · Wilmington, DEBuilt 2006 · S/N 1612 N774SRLevesque Jay F · Rochester, NHBuilt 2007 · S/N 2747 N774TRMb Air Inc · Fort Myers, FLBuilt 2021 · S/N 5046 N7759WGoedecke Chris A · Whitesboro, TXBuilt 1979 · S/N 28-7916411 N775CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2002 · S/N 0228 N775DLN775dl LLC · Orange, CABuilt 2012 · S/N 4636550 N775EWThree Three Foxtrot Inc · Cedar Falls, IABuilt 2003 · S/N 0526 N775GParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020243 N775NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881043 N775PPAims Community College · Greeley, COBuilt 2024 · S/N 2881783 N775SCZw Air LLC · Little Rock, ARBuilt 1981 · S/N BB-808 N775WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 10114 N7763BWyndymere Harbor LLC · Port Saint Lucie, FLBuilt 2016 · S/N 4425 N7763YBen Shuzen LLC · White Plains, NYBuilt 2023 · S/N 9252 N776AMPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4636876 N776CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881764 N776CDTriple Crown Aviation LLC · Las Vegas, NVBuilt 2004 · S/N 1039 N776GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881472

Back to AD 2008-06-28 R1