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.

N311EFLibra Air Inc · Las Vegas, NVBuilt 1979 · S/N 44-7995226 N311FPWalls James · Fernandina Beach, FLBuilt 2018 · S/N 2432 N311GAtp Taa LLC · Wilmington, DES/N 2881422 N311JFGrowers LLC · Mohall, NDS/N 4622039 N311JSGrey Moose Aviation LLC · Los Gatos, CAS/N 9339 N311KFAlpha Papa LLC · Fort Stockton, TXBuilt 1999 · S/N 4636194 N311KNViking Aircraft Leasing LLC · Bethel, MNBuilt 2009 · S/N 3440 N311LGCorporate Aviation Partners I LLC · Fort Worth, TXBuilt 2025 · S/N 4636866 N311LSGrace Aviation LLC · Kalispell, MTBuilt 2012 · S/N 2162 N311NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881904 N311RKTango Whiskey Aviation LLC · Punta Gorda, FLBuilt 2014 · S/N 2241 N311SEDiamond B Farms Trucking Inc · Gamaliel, KYBuilt 2003 · S/N 3232011 N311TDWw House Inc · Lumberton, TXBuilt 2010 · S/N 3623 N311TWFairwinds Aviation LLC · Pikeville, NCS/N 40.640 N311YMYour Mom LLC · Saint Paul, MNBuilt 2025 · S/N 10897 N311ZZJaffa LLC · Sheridan, WYBuilt 2026 · S/N 11279 N3120ETandberg Kjell · Beverly Hills, FLBuilt 2005 · S/N 3257400 N3120TMcbride Matthew T · Eagle River, WIBuilt 2006 · S/N 3257417 N3121VCochise Community College · Douglas, AZBuilt 2006 · S/N 2843626 N31222Dc Air LLC · Lebanon, MOBuilt 2004 · S/N 3257354 N3122EKantec Inc · Cary, NCBuilt 1999 · S/N 2843250 N31241Hotel Charlie Aero LLC · Marshville, NCBuilt 2006 · S/N 3246234 N3125GEastern Kentucky University · Richmond, KYS/N 4496214 N3126WHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2006 · S/N 2843621 N3128SGem Equipment Leasing LLC · Emmett, IDBuilt 2006 · S/N 4697251 N3128TWingsleasing LLC · Wichita, KSS/N 4496219 N3129BRaabe Craig A · West Hartford, CTBuilt 2006 · S/N 3257415 N3129SMulletair LLC · Fort Myers Beach, FLFirst renewal noticeBuilt 2006 · S/N 4697256 N312ADAltier Daniel T · Bloomfield Twp, MIBuilt 2005 · S/N 1615 N312AETwo Creek Capital LLC · Fayetteville, ARBuilt 2019 · S/N 4783 N312APAtish LLC · Hermosa Beach, CABuilt 2025 · S/N 10726 N312ARTime Machine Aviation LLC · Cleveland, TNBuilt 2015 · S/N 2284 N312AZA & J Aviation Rental LLC · Dublin, OHBuilt 2017 · S/N 2344 N312BAAircraft Partner Holdings Inc Trustee · BerlinS/N 1630 N312CADunn Jonathan · Murfreesboro, TNBuilt 1968 · S/N 28R-30590 N312CPSsi Mechanical LLC · San Antonio, FLBuilt 2008 · S/N 3120 N312CTCt Air LLC · Clovis, NMBuilt 2025 · S/N 10867 N312DATspy Services Inc · Wilmington, DEBuilt 2005 · S/N 1262 N312DD312dd LLC · Greenville, SCBuilt 2012 · S/N 2153 N312ESGolden Age N312es LLC · Norwalk, IABuilt 2022 · S/N 2881587 N312FPEger Aviation LLC · Pittsburgh, PABuilt 2014 · S/N 4069 N312GTKiser Consulting LLC · Atlanta, GABuilt 2022 · S/N 8920 N312JBBadmia LLC · Polk City, IAFirst renewal noticeBuilt 2002 · S/N 0373 N312JGJoule Resources LLC · Bellaire, TXBuilt 2006 · S/N 41691 N312MSGulf Of America Aviation LLC · Brookshire, TXBuilt 2023 · S/N 9185 N312NGNovember Golf LLC · Shamong, NJBuilt 2015 · S/N 4274 N312PXRauschenberger Ventures LLC · Chicago, ILBuilt 2021 · S/N 5014 N312REBlue Jay Family Office LLC · Wilmington, DEBuilt 2025 · S/N 11073 N312SRStorm Consulting Enterprises LLC · Tyler, TXBuilt 2007 · S/N 2427 N312SSKellphen Aviation LLC · Montgomery, ALBuilt 2024 · S/N 9911

Back to AD 2008-06-28 R1