Registered aircraft · 16,284

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.

N847TCTexas State Technical College · Waco, TXBuilt 2023 · S/N 28020147 N8482XRegistered aircraftBuilt 2016 · S/N 40.839 N8483FPlanchon Ben P · Menifee, CABuilt 1976 · S/N 28-7790250 N8484FAero Activites LLC · Edgewood, NMBuilt 1976 · S/N 28-7790251 N848AAAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881848 N848BDEuroaviation Inc Trustee · KematenBuilt 2007 · S/N 2677 N848CBAarmark Beer Gardens · Solvang, CABuilt 2007 · S/N 2515 N848DEHunter Jackson Clay II · Saint Louis, MOBuilt 2014 · S/N 4159 N848EFLufthansa Aviation Training USA Inc · Goodyear, AZBuilt 2018 · S/N 2407 N848JBBoshart Aviation LLC · Ridgewood, NJBuilt 2024 · S/N 9939 N848MAztec Software LLC · Chandler, AZBuilt 2007 · S/N 2662 N848MAIcarus Flying Academy LLC · Farmingdale, NYBuilt 2026 · S/N 28020270 N848MDPls Asset Management LLC · Shreveport, LABuilt 2017 · S/N 4528 N848MEAes Aviation LLC · Yorktown, VABuilt 2006 · S/N 1823 N848SRAircan North LLC · Tucson, AZBuilt 2007 · S/N 2836 N848TLoggerhead Reef Aviation LLC · Jupiter, FLBuilt 1989 · S/N 3213027 N848TCTexas State Technical College · Waco, TXBuilt 2023 · S/N 28020148 N8494FPlane Viewing LLC · Colbert, WABuilt 1976 · S/N 28-7790252 N8495FKing Robert M · Fall River Mills, CABuilt 1976 · S/N 28-7790253 N8496FSoriano Juan H · Travelers Rest, SCBuilt 1976 · S/N 28-7790254 N849AAAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881849 N849ATAtp Taa LLC · Wilmington, DEBuilt 2023 · S/N 4496567 N849CMBerome Investments LLC · Wilmington, DES/N 11106 N849EFLufthansa Aviation Training USA Inc · Goodyear, AZBuilt 2018 · S/N 2412 N849WMVette Air Inc · St Johns, FLBuilt 2007 · S/N 2785 N84AUCapital Holdings 242 LLC · Newark, DES/N 3257464 N84BGCirrus Design Corp · Duluth, MNS/N 11796 N84CANeojet N84ca LLC · Reno, NVBuilt 1976 · S/N BB-166 N84HMGo Aviation LLC · Fuquay Varina, NCBuilt 2024 · S/N 10118 N84KAEpix Air LLC · Worthington, MNBuilt 1981 · S/N 32R-8129052 N84KLSpitfire-173 & Partners LLC · New Bern, NCBuilt 1999 · S/N 3246128 N84LAMav Air LLC · Rigby, IDBuilt 1980 · S/N 32R-8029102 N84MHMmm&B Holdings LLC · Clayton, NYBuilt 2026 · S/N 11327 N84MRFreeland Robert S · Knoxville, TNBuilt 2001 · S/N 1118 N84PDSosbey L Paul · Little Torch Key, FLBuilt 2002 · S/N 0231 N84PWFlying Gearheads LLC · Huntsville, ALBuilt 2002 · S/N 0302 N84SSHoffman Thomas A- Trustee · Emmett, KSBuilt 1980 · S/N 32R-8013101 N84VBPiper Aircraft Inc · Vero Beach, FLS/N 4636881 N84WBG-Flights Aviation LLC · Lakeland, FLBuilt 2021 · S/N 2695 N84WTAndreotti Mark C · Colusa, CABuilt 2004 · S/N 3255021 N84XPF B T Services LLC · Portland, ORBuilt 1979 · S/N BB481 N8503EB&B Aviation Holdings LLC · Pembroke Pines, FLBuilt 1976 · S/N 28-7690175 N850ATAtp Taa LLC · Wilmington, DEBuilt 2023 · S/N 4496568 N850BKRpm Consulting LLC · Middletown, DEBuilt 1981 · S/N BB-896 N850DSR&I Dry Willow LLC · Payson, UTBuilt 2007 · S/N 40.750 N850EBNo Step On Snek LLC · Punta Gorda, FLBuilt 2024 · S/N 10334 N850EFLufthansa Aviation Training USA Inc · Goodyear, AZBuilt 2018 · S/N 2413 N850FSParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020072 N850HLHoward Aviation LLC · Santa Rosa Beach, FLBuilt 2023 · S/N 9604 N850PUTrustees Of Purdue University · West Lafayette, INS/N 2881323

Back to AD 2008-06-28 R1