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.

N309LSPure Pursuit LLC · Arnold, MDBuilt 2022 · S/N 8659 N309MGGeorgia Aviation Authority · Eastman, GABuilt 2026 · S/N 28010015 N309NDUniversity Of North Dakota · Grand Forks, NDBuilt 2024 · S/N 2881781 N309PABird Acquisition LLC · Phoenix, AZBuilt 2002 · S/N 2843508 N309PTNelems Manufacturing LLC · Beaufort, SCBuilt 2007 · S/N 2434 N309SCCalcote Derrick · Arlington, TNBuilt 2006 · S/N 2207 N309SRWise Aviation LLC · Atlanta, GABuilt 2007 · S/N 2309 N30CXJaguar Air Inc · Valparaiso, INFirst renewal noticeBuilt 2008 · S/N 4697382 N30KCSkillman Management LLC · Wellington, FLBuilt 1977 · S/N LW-241 N30LVNorth Arkansas Aviation LLC · Paragould, ARS/N 28-7916098 N30NDPak Aviation LLC · Birmingham, ALBuilt 2001 · S/N 3449233 N30PNMountain Air Aircraft Leasing LLC · Great Falls, VABuilt 2021 · S/N 2739 N30SETradewinds 12/21 Inc · Denison, TXBuilt 1977 · S/N BB313 N31008China Saratoga Airline Inc Trustee · Wilmington, DEBuilt 2005 · S/N 3246229 N3103ESpartan Education LLC · Tulsa, OKBuilt 2004 · S/N 4496188 N3104CFlight Training Aircraft LLC · Wilmington, DEBuilt 2004 · S/N 4496190 N31062Central Virginia Aviation Inc · Petersburg, VABuilt 2005 · S/N 4697208 N31082Bershire Aviation Enterprises LLC · Great Barrington, MAS/N 28-7816551 N31087Lvr Air Inc · East Hartford, CTBuilt 2005 · S/N 3232044 N3109PSoft Works Systems Inc · Jamesville, NYBuilt 1969 · S/N 28R-31109 N310ELFly Ivy LLC · Brighton, MABuilt 2024 · S/N 9795 N310FLD & T Outlaw Properties LLC · Dallas, TXBuilt 2009 · S/N 3534 N310GSKnot So Fast Aviation Inc · Kernersville, NCBuilt 1979 · S/N 28-8090140 N310JFAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2485 N310JKConnors Air Holdings LLC · Tierra Verde, FLBuilt 2001 · S/N 4697069 N310MAMbm Leasing LLC · Saint Louis, MOBuilt 2023 · S/N 28020104 N310PPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 2414 N310SATailwind LLC · Cameron, NCBuilt 2019 · S/N 4812 N310SMRegistration Pending · Pocatello, IDRegistration pendingS/N 2046 N310SUOklahoma State University · Stillwater, OKBuilt 2019 · S/N 2521 N310TNFarfalla Aviation LLC · Santa Rosa, CABuilt 2006 · S/N 2146 N310VPN310vp LLC · Galena, OHBuilt 2001 · S/N 0054 N3110TWellborn Aviation LLC · Texarkana, TXBuilt 2005 · S/N 4697221 N31110Anica Properties LLC · Chandler, AZBuilt 2005 · S/N 3449319 N3111CSalt Air Aviation LLC · Chapel Hill, NCBuilt 2006 · S/N 3232057 N3111KChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 4496240 N31122Ross Jeremy · Lufkin, TXBuilt 2005 · S/N 3257394 N3112KBeilman Charles C · Wallingford, CTBuilt 2021 · S/N 5123 N3112WAbba Shield LLC · Kalispell, MTS/N 3255036 N3114ATavallaee Mehran Monazam · Crossville, TNBuilt 2008 · S/N 3257490 N3114W865 Aviation LLC · Knoxville, TNBuilt 2021 · S/N 5117 N3114XNorthgate Aviation Inc · Chico, CABuilt 2005 · S/N 3232052 N3116CNorthfork Aviation LLC · Columbia, MOS/N 3246233 N3117AAtp Aircraft 8 LLC · Wilmington, DEBuilt 2008 · S/N 4496259 N3117KDegatech Systems Inc · Van Nuys, CABuilt 2005 · S/N 3257398 N3117LAtp Aircraft 2 LLC · Wilmington, DEBuilt 2005 · S/N 4496202 N3117QLynch Mark E · Granite Bay, CABuilt 2005 · S/N 3257403 N3117SBlue Horseshoe LLC · Brentwood, TNBuilt 2005 · S/N 4697230 N3117VP&C Aircraft LLC · Chapel Hill, NCBuilt 2005 · S/N 4697234 N311AVCane Associates Aviation Consultants LLC · Mount Pleasant, SCBuilt 2007 · S/N 2395

Back to AD 2008-06-28 R1