Registered aircraft · 16,284

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.

N91834Skylink Xpress Inc · San Bernardino, CABuilt 1989 · S/N 2841141 N918AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881947 N918ASFarley Scott S · Ellington, CTBuilt 1998 · S/N 3257029 N918DWHigh 5 Aviation LLC · Naples, FLBuilt 2013 · S/N 4002 N918GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881074 N918GVPhoenix Air LLC · Rayville, LABuilt 2018 · S/N 4646 N918KJetko LLC · Boston, MABuilt 2015 · S/N 4217 N918LPowers Aircraft Sales And Leasing Inc · Longwood, FLBuilt 2000 · S/N 3246162 N918LVLandreth David L · Houston, TXBuilt 2006 · S/N 41578 N918MANewman Aviation Services Inc · Tiffin, OHBuilt 1998 · S/N 3246118 N918PABird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843307 N918PBBulls Air LLC · Port Charlotte, FLBuilt 2015 · S/N 4278 N918PGInternational Air Services Inc Trustee · Carson City, NVS/N 1975 N918VMDimare Vincent M Jr · Georgetown, TXBuilt 2023 · S/N 9636 N918VSDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N LW-200 N918WTPetrunyak Matthew A · Clover, SCBuilt 2013 · S/N 2232 N918ZBrewton Aerospace LLC · Boston, MABuilt 2024 · S/N 9941 N918ZTMs Air LLC · Hickory, NCBuilt 2008 · S/N 4692015 N91902Ebe Aviation LLC · Urbandale, IABuilt 1990 · S/N 4622094 N9191DPorter William C Jr · Vicksburg, MSS/N 3213032 N9191N9191n LLC · Salem, NHBuilt 1989 · S/N 2890136 N9191VMilville Aviation LLC · Wilmington, DEBuilt 1989 · S/N 3213033 N9193RLos Compadres Ranch · Premont, TXBuilt 1990 · S/N 4622098 N9195KWatson Joseph L Jr · Concord, NCBuilt 1976 · S/N 28-7690227 N9197BEsteban John G · Dublin, NHBuilt 1993 · S/N 2890192 N9199POther Woman LLC · Gulf Shores, ALBuilt 1990 · S/N 4622107 N919AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881948 N919BAWhat A View Aviation LLC · Andalusia, ALBuilt 2022 · S/N 8698 N919BHH4 Aviation LLC · Boerne, TXBuilt 1982 · S/N 441-0257 N919CDHigh Wings Inc · York, PABuilt 2002 · S/N 0278 N919MAValiair Lc Trustee · Casper, WYBuilt 2014 · S/N 4697556 N919REIvy Brothers Aviation LLC · Kilgore, TXS/N BB824 N919RFRegion Flyers LLC · Valparaiso, INBuilt 1981 · S/N 28-8216062 N919SCLand 2 Air Investments LLC · Southlake, TXBuilt 2006 · S/N 2112 N919SESierra Echo Adventures LLC · Raleigh, NCBuilt 2006 · S/N 2215 N919SPGorman Kevin V · Ebensburg, PABuilt 1999 · S/N 3257113 N919SRPalustris Holdings LLC · Thomasville, GABuilt 2007 · S/N 2713 N919TKTk Aero LLC · Raleigh, NCBuilt 2026 · S/N 11467 N919TLRegistered aircraftBuilt 2002 · S/N 0182 N919WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 10264 N91AUScreaming Duck Air LLC · Houston, TXS/N 32R-8129017 N91BFPlatinum Storage Properties LLC · Wayzata, MNBuilt 1981 · S/N 441-0245 N91EENorthern Tier Private Investg & Security Cnslg Inc · Towanda, PABuilt 1982 · S/N 28-8390005 N91FBAircraft Partner Holdings Inc Trustee · BerlinBuilt 2003 · S/N 3257314 N91GCSilver Bear Transport LLC · Santa Ana, CABuilt 2011 · S/N 40.1128 N91MFCkw Aviation LLC · Dalhart, TXBuilt 1980 · S/N BB-657 N91MKMulaii LLC · Wilmington, DEBuilt 2014 · S/N 4636647 N91NETango Aviation LLC · Farmington, UTBuilt 2005 · S/N 1500 N91SABoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2006 · S/N 1710 N91VXB&R Aviation LLC · Bozeman, MTBuilt 2023 · S/N 9510

Back to AD 2008-06-28 R1