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.

N407KPDelta Consulting & Real Estate LLC · Manila, ARBuilt 2018 · S/N 4687 N407SGriffing Flying Service Inc · Port Clinton, OHBuilt 1979 · S/N 28-7990545 N407ST5x Sr22 LLC · Sandy Springs, GABuilt 2022 · S/N 8917 N4085QWarrior 85q LLC · Vero Beach, FLS/N 28-7716170 N408ABRite A Way Services Inc · Riverside, CAS/N 411090 N408AVWestwind School Of Aeronautics Phoenix DBA · Goodyear, AZBuilt 2022 · S/N 8778 N408CAndonie Lourdes C · Mcallen, TXFirst renewal noticeBuilt 2006 · S/N 4636405 N408CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881119 N408CDKc Jet Sales LLC · Scottsdale, AZBuilt 2005 · S/N 1464 N408JHSunshine And Tailwinds Aviation LLC · Brandon, MSBuilt 2022 · S/N 8906 N408KMRivers Aviation LLC · Houston, TXBuilt 2022 · S/N 8968 N408LWParis Air Inc · Vero Beach, FLS/N 28-7716114 N408NDKnowlton Dane F · Camden, ALBuilt 2005 · S/N 1599 N408PGJs Extra 300 LLC · Dallas, TXBuilt 2008 · S/N 2984 N408RFFogel Services Inc · Ladson, SCBuilt 2024 · S/N 9895 N408WGBlue Sky 408 LLC · Lakeland, TNBuilt 2009 · S/N 3565 N408ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881669 N4090QWieczorek Alan · Lees Summit, MOS/N 28-7716171 N4098QLongleaf Auction LLC · Williamston, NCS/N 28-7790471 N409AKHenderson Kim · Everett, WABuilt 1998 · S/N 3257072 N409AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2022 · S/N 8794 N409CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881120 N409CCPappy Air LLC · Pickerington, OHBuilt 2023 · S/N 28020113 N409CDArmbruster LLC · Amherst, OHBuilt 2005 · S/N 1286 N409CFFox Charles · Massapequa Park, NYBuilt 2005 · S/N 1600 N409CPHornowski Consulting Inc · Asheville, NCBuilt 2006 · S/N 4636375 N409DParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020224 N409HAFalcon Flight And Investments LLC · Lewes, DEBuilt 2008 · S/N 411039 N409KJBoard Of Trustees · Battle Creek, MIBuilt 2021 · S/N 4496523 N409RATurbo Air Charter LLC · Boise, IDBuilt 1978 · S/N BB-429 N409SJKirsh & Kirsh P C · Indianapolis, INBuilt 2005 · S/N 42084 N409TPParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020073 N409TTMad Dog Air LLC · Spotsylvania, VABuilt 2009 · S/N 421020 N40ADCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11540 N40BZHazlewood Aviation LLC · Wichita, KSFirst renewal noticeBuilt 2008 · S/N 411034 N40CXSchuette David A · Flemington, NJBuilt 2006 · S/N 41670 N40CYGross William Patrick · Pine Bluffs, WYBuilt 2005 · S/N 41075 N40GDSimply Living LLC · Fort Myers, FLBuilt 2003 · S/N 0473 N40HPRock Communications LLC · Rock Hill, SCBuilt 2000 · S/N 4636264 N40JAJersey Aero Club Inc · Lakewood, NJBuilt 1985 · S/N 28-8616036 N40JGSimms Charles Jr · Lexington, KYBuilt 1968 · S/N 28R-30953 N40KLConstantine Lucas L · Inglewood, CAS/N 40.316 N40MAIndia Juliet Mike LLC · Youngsville, LABuilt 2008 · S/N 4697354 N40RDynamic Avlease Inc · Bridgewater, VABuilt 1975 · S/N BC-7 N40RZTwin Trails LLC · Draper, UTBuilt 1995 · S/N 4636009 N40SFSterling Flight Training LLC · Jacksonville, FLBuilt 2020 · S/N 2881377 N40TSIst Solutions Inc · Los Angeles, CAFirst renewal noticeBuilt 2010 · S/N 4692156 N40XEFly Diamond Da40 N40xe LLC · Kalispell, MTBuilt 2002 · S/N 40.208 N40YMN40ym LLC · Mattituck, NYBuilt 2025 · S/N 10616 N4100QTailwinds Flying Club · Hudson, WIS/N 28-7790472

Back to AD 2008-06-28 R1