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.

N3327PNewsome Charles Robert · Villa Rica, GABuilt 1988 · S/N 3213013 N332AD542 Bridge LLC · Arlington, VABuilt 2025 · S/N 10710 N332BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2018 · S/N 2881083 N332CAPhysicians Air Transport LLC · Hot Springs, ARBuilt 1981 · S/N BB-816 N332CDDuggar Aviation LLC · Springdale, ARBuilt 2004 · S/N 0873 N332CVYates Philip Arthur · Allen, TXBuilt 1996 · S/N 3246048 N332DAHanford Equipment LLC · Eagle, IDS/N 3453 N332DMKm Aviation LLC · Overland Park, KSBuilt 1980 · S/N 441-0167 N332GTArminair LLC · Dover, DEBuilt 2008 · S/N 3332 N332KCAdams William M · Southlake, TXBuilt 2003 · S/N 3257332 N332LMLumbra Ronnie E · Rye, NYBuilt 2005 · S/N 1332 N332MMRan Health Services Inc · Modesto, CABuilt 2025 · S/N 10749 N332PABird Acquisition LLC · Phoenix, AZS/N 2843515 N332TTAlta Vista Enterprises LLC · Sheridan, WYBuilt 2009 · S/N 3525 N3331QEvangelista Ronald · Castle Rock, COBuilt 1977 · S/N 28-7716148 N3334QViking Aerial Photography LLC · Zionsville, INBuilt 1977 · S/N 28-7790449 N333ARLe Bon Air Inc Trustee · Wilmington, DEBuilt 2004 · S/N 0844 N333EAExecutive Air Services LLC · Opa Locka, FLBuilt 2026 · S/N 11373 N333EFTmak Inc · Visalia, CABuilt 1998 · S/N 3257053 N333GCDlx Rzl LLC · Rensselaer, INBuilt 2006 · S/N 4636383 N333GFDirty Side Down Aviation LLC · Georgetown, TXBuilt 2024 · S/N 10124 N333HMVia Vitae Aviation LLC · Lexington, KYBuilt 1981 · S/N 32R-8113096 N333KQQuarles Transportation LLC · Bolivar, MOBuilt 2023 · S/N 9597 N333LLNutex Concepts Of North Carolina Corp · Lenoir, NCBuilt 2017 · S/N 4447 N333LNYour Mom LLC · Richfield, MNBuilt 2019 · S/N 2489 N333NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881782 N333NYAvery Anne Leasing LLC · Rocky Point, NYBuilt 2016 · S/N 4373 N333PXTime Investment Corp · Greenville, NCBuilt 2011 · S/N 3791 N333QKPcg Aviation LLC · Charleston, SCBuilt 2025 · S/N 11014 N333WRRes Ipsa Aviation LLC · Atlanta, GABuilt 2022 · S/N 4636809 N333WSMuller Gabriel J · Leesburg, VABuilt 2004 · S/N 0906 N333YYZentrax Inc · North Hollywood, CABuilt 2020 · S/N 2641 N3343QGallmeyer Vernon H DBA · Louisville, COS/N 28-7716151 N3344QGrinch Robert J · Ridgewood, NJBuilt 1977 · S/N 28-7790452 N334ACRegistration Pending · Farmingdale, NYRegistration pendingBuilt 2005 · S/N 2842219 N334BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2018 · S/N 2881084 N334CCil Aviation LLC · Indianapolis, INBuilt 2016 · S/N 4636707 N334CKLyders-Petersen Peter · Brighton, MIBuilt 2004 · S/N 3246222 N334DATwo Knuckleheads & An Airplane LLC · Georgetown, TXBuilt 2009 · S/N 3396 N334GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881116 N334MRN334mr LLC · New York, NYBuilt 2022 · S/N 8577 N334NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881793 N334STLee Scott Tyler · Cypress, TXS/N 4697334 N335ASeals Richard S · Key Colony Beach, FLBuilt 2006 · S/N 2288 N335ACRegistration Pending · Fort Pierce, FLRegistration pendingBuilt 2006 · S/N 2842274 N335BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2018 · S/N 2881085 N335CPMcbride John F Jr · Billerica, MABuilt 2008 · S/N 3250 N335MKNorth Star Aviation Inc · Mankato, MNBuilt 2018 · S/N 2881090 N335PGSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 1504 N335TAN335ta LLC · Anchorage, AKBuilt 1979 · S/N BB-514

Back to AD 2008-06-28 R1