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.

N718CLBlue Sky Holdings LLC · Brule, NEBuilt 2019 · S/N 4818 N718DLZhang Boying Barry · Wshngtn Xing, PABuilt 2005 · S/N 40.542 N718KTGeorgia Aviation Authority · Eastman, GABuilt 2007 · S/N 2843653 N718NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2016 · S/N 2843852 N718PWCessna 400 LLC · Mesa, AZBuilt 2007 · S/N 41781 N718SPCirrusly LLC · Edmond, OKBuilt 2015 · S/N 4185 N718SRLone Mountain Aircraft LLC · Springfield, OHBuilt 2006 · S/N 2252 N718STSherman Gregory D · Tallahassee, FLBuilt 2023 · S/N 9487 N718TALean Of Peak Aviation LLC · Kempner, TXBuilt 2021 · S/N 2746 N718TDSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2022 · S/N 4636813 N718TLBuildup LLC · Naples, FLFirst renewal noticeBuilt 2014 · S/N 4103 N7199CCirrus Design Corp · Duluth, MNS/N 11665 N719BHWilliams Farms LLC · Panhandle, TXBuilt 1979 · S/N BB-564 N719CMLucky Arc Holdings LLC · Saint Petersburg, FLBuilt 2013 · S/N 2239 N719CSDavis Robert · Presque Isle, MEBuilt 2012 · S/N 3832 N719DCRosse Bradley E · Concord, MABuilt 2006 · S/N 2069 N719EDWerner Thomas · Grand Island, NEBuilt 2007 · S/N 2758 N719LMPurcell Daniel G · Spotsylvania, VAS/N 0590 N719MMagnolia Underground Construction Inc · Byhalia, MSBuilt 2007 · S/N 40.851 N719NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2016 · S/N 2843854 N719PPCirrus Design Corp · Duluth, MNS/N 11700 N719SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 2269 N719TAFlight Level Change LLC · Brookshire, TXBuilt 2024 · S/N 9964 N719TMInnovative Flight Systems LLC · Lewes, DEBuilt 2026 · S/N 11500 N71CVGo To Fly LLC · North Miami, FLBuilt 2020 · S/N 4976 N71DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010071 N71ELCaptain Jb LLC · Findlay, OHBuilt 2006 · S/N 41613 N71GVVermeer Manufacturing Co · Pella, IAS/N 10081 N71LAHaralson Catherine Laura Kessler · Gadsden, ALBuilt 2005 · S/N 40.471 N71LZGriffin Ralph J Jr · Thibodaux, LABuilt 1977 · S/N 28-7816275 N71NAYe Services Inc · Bradenton, FLBuilt 1981 · S/N 34-8233017 N71PEEairco LLC · Nacogdoches, TXBuilt 2024 · S/N 10150 N71PFPjf Air LLC · Farmingdale, NYBuilt 2018 · S/N 4722 N71PRCti Aircraft Leasing LLC · Memphis, TNS/N 2881302 N71RDRagincajun Aviation LLC · Missoula, MTBuilt 2010 · S/N 4697438 N71RLPatriot Capital Ventures LLC · Mokena, ILBuilt 2001 · S/N 3246197 N71TWThink West Investments LLC · Middletown, DEBuilt 2005 · S/N 1455 N71TZShell Less Turtle LLC · Chesterfield, MOBuilt 2025 · S/N 10512 N71UMUniversity Of Maine System · Augusta, MEBuilt 2022 · S/N 8671 N71VTWestern Wings Corp · Roseburg, ORBuilt 1980 · S/N BB-709 N71VUVincennes University · Vincennes, INBuilt 2026 · S/N 11188 N71WBEagle Air Transport Inc · Ottawa, ILBuilt 1974 · S/N LW-127 N71WZArlington Aviation Inc Trustee · Wilmington, DEBuilt 2000 · S/N 4636275 N71YP71yp LLC · Milton, GABuilt 2026 · S/N 11183 N720CDDewitt 2 LLC · Evansville, INBuilt 2001 · S/N 0010 N720CGThird Aviation LLC · Fairfield, NJBuilt 2023 · S/N 9755 N720CTDucksauce Transportation LLC · Boca Raton, FLBuilt 2010 · S/N 3666 N720DGFreedman Roger A · Saint Petersburg, FLBuilt 2002 · S/N 1174 N720ECEast Coast Aviation LLC · Falmouth, MEBuilt 2004 · S/N 1218 N720FARegistered aircraftBuilt 2007 · S/N 1869

Back to AD 2008-06-28 R1