Registered aircraft · 16,290

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.

N119ANClear Skies Aviation LLC · Broadlands, VABuilt 2020 · S/N 2547 N119AVFour Mac Air LLC · San Diego, CABuilt 1984 · S/N 28-8490079 N119BTDelaware US Investments LLC · Corpus Christi, TXBuilt 2022 · S/N 2881522 N119GSDall James R Jr · Hayes, VABuilt 1985 · S/N 32R-8529009 N119LKMy Wings LLC · Eden Prairie, MNBuilt 2016 · S/N 4366 N119MKFlatirons Aviation LLC · Naples, FLBuilt 2011 · S/N 2084 N119PEDoo Me Too LLC · Spearfish, SDS/N 411043 N119PMMisunas Peter V Trustee · Redondo Beach, CABuilt 2014 · S/N 4692205 N119RPTrdz LLC · El Segundo, CABuilt 2018 · S/N 2457 N119TPJt Executive Properties LLC · Italy, TXBuilt 2008 · S/N 4697386 N119UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1225 N119WJLauber Land Developers LLC · Saint Louis, MOS/N 3978 N119WKOntop Airops LLC · Maumee, OHBuilt 2003 · S/N 4636348 N119WZWhiskey Zulu LLC · Urbandale, IABuilt 2002 · S/N 0414 N11CASky Dragon LLC · Atlanta, GAS/N 28-8190077 N11CTNwm Advisors LLC · San Luis Obispo, CABuilt 2020 · S/N 4960 N11DFFull Flaps 11df LLC · Malvern, PABuilt 2024 · S/N 10337 N11DTAzul Air LLC · Dover, DEBuilt 1972 · S/N LW-11 N11FLBell Christopher K · Ashley, OHBuilt 1968 · S/N 28R-30444 N11HKJohnson Wendell F · Harlingen, TXBuilt 1981 · S/N 32R-8129071 N11MMN11mm LLC · Anchorage, AKBuilt 1979 · S/N 441-0105 N11MZD&K Harvesting Inc · Labelle, FLBuilt 2001 · S/N 0108 N11PRGo Anywhere Do Anything LLC · South Lake Tahoe, CAS/N 2307 N11PSPro Ag Aviation LLC · Luverne, MNBuilt 2025 · S/N 10497 N11SDHarris County Sheriffs Office · Spring, TXBuilt 2020 · S/N 4957 N11SUSouthern Utah University · Cedar City, UTBuilt 2017 · S/N 2359 N11UZEastern Stearman Inc Trustee · Leesburg, VAS/N 3213063 N11WAlae Exploration LLC · Gainesville, FLBuilt 2002 · S/N 0262 N11WZVip Poppy LLC · Sheridan, WYBuilt 2022 · S/N 8640 N11XTKacur John Edward Sr · Halethorpe, MDBuilt 2000 · S/N 1103 N11ZMJr Aircraft Services LLC · Oxford, MIBuilt 2004 · S/N 40.460 N1202HAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2024 · S/N 4636836 N1205SCounty Line Aviation LLC · Benton, KSBuilt 1979 · S/N LW-319 N1207C3 Rs Incorporated · Perry Hall, MDBuilt 2003 · S/N 0455 N1207HVenture West LLC · Mesa, AZS/N 28-7790295 N1208HWaldel Ltd · West Lafayette, INS/N 28-7790296 N120DGBluesail LLC · Las Vegas, NVBuilt 1981 · S/N 32R-8129077 N120DSElement Aero LLC · Chicago, ILBuilt 2002 · S/N 40.220 N120FWRaabe Travel LLC Series 1 · Whitehouse, TXBuilt 1998 · S/N 4636134 N120MGParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020071 N120MXSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2015 · S/N 2281 N120PTPi Air LLC · Malibu, CABuilt 2022 · S/N 4636797 N120RHAir Puerto Rico Corp · Aguadilla, PRBuilt 1978 · S/N 44-7995118 N120RLIsr Platforms LLC · Mclean, VABuilt 1979 · S/N BT-9 N120TKNew Leaf Consulting Inc · Raleigh, NCBuilt 2012 · S/N 2156 N120WPHentschel Ernest · Galloway, NJBuilt 2005 · S/N 1630 N120WWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2001 · S/N 4697047 N1211DWest Ridge Ttx LLC · Parker, TXBuilt 2008 · S/N 411104 N1212CDodson International Parts Inc · Rantoul, KSBuilt 1985 · S/N 441-0346 N1213MOlson Sandra K · Edmonds, WABuilt 2006 · S/N 42543

Back to AD 2008-06-28 R1