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.

N51VBPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 4496616 N51XJKalm Skies LLC · Mobile, ALS/N 4611 N520AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2021 · S/N 28020049 N520AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2023 · S/N 9574 N520BBJ S Aviation Corp · Farmingdale, NYBuilt 2006 · S/N 2842257 N520BCMitchell Bruce P · Medford, ORBuilt 2004 · S/N 0996 N520CLRobo Holdings LLC · Tampa, FLBuilt 2024 · S/N 10228 N520CWCentral Washington University · Ellensburg, WABuilt 2017 · S/N 2843921 N520DDThomas Asset Group Ltd · Springtown, TXBuilt 1980 · S/N BB-738 N520DSFsck N520ds Inc Trustee · Wilmington, DEBuilt 2006 · S/N 40.620 N520HPHutton Mark · Denison, TXBuilt 2000 · S/N 46-97012 N520MAL3 Wolfpack Sigma LLC · Lenexa, KSBuilt 1996 · S/N 32-46020 N520MCBedrock LLC · Anniston, ALBuilt 1975 · S/N BB-43 N520MSH2 Link Co · Chino, CABuilt 2006 · S/N 4496230 N520SUSeries D Of Boelte Aviation LLC · Wilmington, DEBuilt 2024 · S/N 9983 N520WKOld Landing Aviation LLC · Great Falls, VABuilt 2011 · S/N 3797 N520XSwaz Aviation LLC · Mesa, AZBuilt 1978 · S/N 28-7816582 N520YZRed Phoenix Inc · Newport Beach, CABuilt 2015 · S/N 2279 N5215UTwin Peaks Aviation LLC · Missoula, MTS/N 4697068 N521ASStanz John Trustee · Maple City, MIBuilt 1982 · S/N 32R-8229051 N521BASynergy Aircraft Sales LLC · Bloomington, ILBuilt 2006 · S/N 1614 N521BTBennett Brady R · Pinehurst, NCBuilt 2003 · S/N 0752 N521CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2441 N521CMShafique Tajammul · Gilford, NHBuilt 2005 · S/N 1558 N521CWCentral Washington Univ · Ellensburg, WABuilt 2017 · S/N 2843922 N521DAUmanah Aviation LLC · Waldorf, MDBuilt 2023 · S/N 9506 N521DDUrbana Aviation LLC · Woodstock, OHBuilt 2002 · S/N 40.215 N521FTR & G Aviation LLC · Hazlehurst, GABuilt 1980 · S/N BL-012 N521GSProteng Distribution Inc · Wellington, FLBuilt 2007 · S/N 41765 N521HWCirrus Design Corp · Duluth, MNS/N 11781 N521LCRegistered aircraftN-number assigned (import), not yet registeredS/N 2007 N521LMTavallaee Mehrdad M · Ashland, OHBuilt 2006 · S/N 2243 N521MGHlma LLC · Waverly, WVBuilt 2015 · S/N 4636663 N521PTClub Mike Aviation LLC · Clarksville, TNBuilt 2023 · S/N 9194 N521SRGrauer Stewart M · Cave Creek, AZBuilt 2006 · S/N 1695 N521TSJustice William F · Calabasas, CABuilt 2005 · S/N 1753 N521ZHoffner Flying Inc · Yankton, SDBuilt 2002 · S/N 0176 N521ZMThompson Russell Clayton · Hartland, MIBuilt 2007 · S/N 2583 N5221NBoardman Brian J · Claremont, NHS/N 2843429 N5226RBuncamper Theodore · St MaartenBuilt 2006 · S/N 1767 N522ACrowe Aviation LLC · Vestavia, ALBuilt 2021 · S/N 5139 N522ARMedic Choppers LLC · Springdale, ARBuilt 2005 · S/N 1534 N522CDFbm LLC · La Porte, INBuilt 2002 · S/N 0193 N522CPFly Cirrus LLC · Murrieta, CABuilt 2008 · S/N 3201 N522DDHw Aviation LLC · Largo, FLBuilt 2005 · S/N 1322 N522DGGosnell David · Copperas Cove, TXBuilt 2005 · S/N 40.602 N522DXFd Aircraft LLC · Summit, NJBuilt 2021 · S/N 5064 N522FDCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 10522 N522JWLong Island Aviators LLC · Seaford, NYBuilt 2001 · S/N 2843461 N522KGJdi Electrical Solutions Inc · Temecula, CABuilt 2004 · S/N 1170

Back to AD 2008-06-28 R1