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.

N720FGClark Charles · Basking Ridge, NJBuilt 2025 · S/N 4697720 N720GPCharlie Hotel Corp · Wilmington, DEBuilt 1977 · S/N 28-7790366 N720KMTrubee Jay G Trustee · Palm Desert, CABuilt 2002 · S/N 3257300 N720LMTactical Integrated Training Solutions LLC · Colorado Springs, COBuilt 2006 · S/N 40.720 N720LTCowan Mark · Afton, WYBuilt 2004 · S/N 1059 N720PMurillo Carlos F · Pembroke Pines, FLS/N 0617 N720PAValiair Lc Trustee · Casper, WYBuilt 2000 · S/N 2843386 N720RJRegistered aircraftBuilt 2024 · S/N 9828 N720SHBrooke James B · Salisbury, MDBuilt 1997 · S/N 3246085 N720SUOklahoma State University · Stillwater, OKBuilt 2017 · S/N 4496413 N720TDHdt Aviation LLC · Rockford, ILBuilt 2019 · S/N 4817 N720TXC A Rob Co LLC · Midland, TXBuilt 2005 · S/N 1564 N720UOhio University · Albany, OHBuilt 2005 · S/N 2842223 N720WDThorntons Aircraft LLC · Tuscaloosa, ALBuilt 2003 · S/N 3257327 N720WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 9956 N720XPrecise Aero LLC · Fort Myers, FLBuilt 2011 · S/N 3813 N7210HMenzie Bradley J · Sublette, KSFirst renewal noticeBuilt 1976 · S/N 287690255 N721AP721ap LLC · Erie, COBuilt 2008 · S/N 3069 N721BTEv Services Inc · Destin, FLBuilt 2009 · S/N 3562 N721EAAcellerated Interventional Orthopedics Pllc · Lawton, OKBuilt 1980 · S/N BB-679 N721FJ8th Dimension Enterprises LLC · Aurora, ORBuilt 2021 · S/N 28020027 N721JDBrand Technicians LLC · Encino, CABuilt 2000 · S/N 2843410 N721JSWolansky Brad · Plant City, FLBuilt 1997 · S/N 3449024 N721KWJj Aviation LLC · Dallas, TXBuilt 2023 · S/N 9253 N721MTThesman One Investments LLC · Las Vegas, NVBuilt 2008 · S/N 4697362 N721NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881309 N721PSJust Plane Stuff Inc · Jackson, MSBuilt 2021 · S/N 2743 N721RDKing Edward Inc · Cullman, ALBuilt 1980 · S/N BB677 N721RWGulf Coast Business Advisors LLC · Pineville, LABuilt 2021 · S/N 4636781 N721SMBlue Skies Flying Services Inc · Lake In The Hills, ILBuilt 2000 · S/N 2843337 N721TAT Squared Aviation LLC · Brookshire, TXBuilt 2022 · S/N 8766 N721TPBytra Aviation LLC · Santa Clara, CABuilt 2026 · S/N 11306 N721VCSch Aviation Inc Trustee · SporleBuilt 2002 · S/N 0361 N721WBFox Gary A · Mebane, NCBuilt 2005 · S/N 41107 N721WTTurtlequest LLC · Dover, DEBuilt 2020 · S/N 4944 N722AKInternational Air Services Inc Trustee · Carson City, NVBuilt 1992 · S/N 2890172 N722AMRuiz Michael · Marietta, GABuilt 2007 · S/N 2526 N722BJBravo Juliett LLC · Bermuda Run, NCBuilt 2004 · S/N 1043 N722CDCirrus Design Corp · Duluth, MNS/N 11722 N722DHCirrus Design Corp · Duluth, MNS/N 11719 N722ETSymonds Stephen M · Colleyville, TXBuilt 1996 · S/N 4636047 N722FBHighland Trace Ascension LLC · Baton Rouge, LABuilt 2014 · S/N 4043 N722GTable For Seven Aviation LLC · Mountain Brk, ALBuilt 1997 · S/N 3246066 N722MTValiair Lc Trustee · Casper, WYBuilt 2023 · S/N 9039 N722NCBraymer Aviation LLC · Kearney, MOBuilt 2006 · S/N 1731 N722NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881310 N722PASpoelstra Air LLC · Encinitas, CABuilt 2006 · S/N 40.727 N722PBJ & D Aviation LLC · Salem, WIBuilt 2003 · S/N 0722 N722PLCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 10431 N722RDR & R Aviation New Orleans LLC · New Orleans, LABuilt 2005 · S/N 1558

Back to AD 2008-06-28 R1