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.

N33VUVincennes University · Vincennes, INBuilt 2018 · S/N 4496431 N33WSJak2 Properties LLC · Ocala, FLBuilt 2017 · S/N 4563 N33YCHxd Aircraft Management LLC · Hilton Head Island, SCBuilt 2014 · S/N 2247 N3403DCirrus Design Corp · Duluth, MNS/N 11723 N3406A406a Inc · Hollywood, FLS/N 3257044 N340AUAuburn University · Auburn, ALBuilt 2020 · S/N 4496510 N340BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2022 · S/N 2881526 N340CDArgent Holding (USA) Ltd · Corona, CAS/N 1354 N340PAVidal Aviation LLC · Gaithersburg, MDBuilt 2002 · S/N 2843516 N3411QSillinger Daniel E · Covington, LABuilt 1977 · S/N 28-7716155 N3416QJaouen Dominique · Berlin, CTBuilt 1977 · S/N 28-7790457 N341DCKiener Matthew J · Pottersville, NJBuilt 1996 · S/N 3246044 N341ECPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010041 N341EYEdy Aviation LLC · Framingham, MABuilt 2017 · S/N 4571 N341FTWatkins Robert W II · Parsons, TNBuilt 1982 · S/N 28-8216210 N341MAMistwood Air 1 LLC · Newark, DEBuilt 2024 · S/N 9943 N341MC1 Mc LLC · Johnstown, PABuilt 1995 · S/N 4636018 N341NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881794 N341TAUnited States Of America · Travis Afb, CABuilt 2006 · S/N 2843634 N3427BBoyle Corey J · Robbinsville, NJBuilt 2025 · S/N 10868 N3427DPowers Ryan · Boston, MABuilt 2021 · S/N 5099 N3427MFlagiello Marissa Edwards · San Francisco, CABuilt 1977 · S/N 28-7816341 N342ACC & L Aviation LLC · Swainsboro, GABuilt 2008 · S/N 3051 N342AFMckay Ian · Seattle, WABuilt 2009 · S/N 40.1040 N342BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 2881650 N342CDBlanchard Aviation LLC · Waynesboro, GABuilt 2024 · S/N 9812 N342CZCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11342 N342DSHaynes Gregory P · Opelousas, LAS/N 40042 N342FGDm Equipment Leasing LLC · Parker, COBuilt 2021 · S/N 28020042 N342GFKites Rising LLC · Naples, FLFirst renewal noticeBuilt 2016 · S/N 4342 N342MAStauffer Michael S · Wichita Falls, TXBuilt 1996 · S/N 2843042 N342MKNorth Star Aviation Inc · Mankato, MNBuilt 2019 · S/N 2881260 N342SRRh Air LLC · Slinger, WIBuilt 2007 · S/N 2342 N342TAUnited States Air Force 60 Fss/Fsca · Rio Vista, CABuilt 2006 · S/N 2843645 N342TTLewis Charles Ryan · Napa, CABuilt 2004 · S/N 1236 N342WPPapa LLC · Eufaula, ALBuilt 1977 · S/N 28-7716288 N3432MSears Megan · Rigby, IDBuilt 1977 · S/N 28-7816343 N3437M7550g LLC · Birmingham, MIBuilt 1977 · S/N 28-7890301 N343AMSkyline Aviation Inc · San Angelo, TXBuilt 2007 · S/N 40.822 N343AZVista Aircraft LLC · Willcox, AZBuilt 2025 · S/N 10578 N343BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 2881651 N343BPShelton Joseph H · Fort Worth, TXBuilt 2007 · S/N 2340 N343CDMastin Air LLC · Dover, DEFirst renewal noticeBuilt 2005 · S/N 1343 N343DSStoeppel Anthony · Cynthiana, KYBuilt 2008 · S/N 40.1017 N343HPMonada Air Inc Trustee · Wilmington, DEBuilt 2003 · S/N 3449281 N343MAMonitor Pest Control Inc · Marietta, GABuilt 2001 · S/N 32-46183 N343MKNorth Star Aviation Inc · Mankato, MNBuilt 2019 · S/N 2881261 N343MMN4005u LLC · Iron Mountain, MIBuilt 1999 · S/N 28-43266 N343NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 2881890 N343RCHoekstra David A · Roswell, NMBuilt 2007 · S/N 41768

Back to AD 2008-06-28 R1