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.

N548CPF Partnoy Inc · San Diego, CABuilt 2008 · S/N 3329 N548CWCentral Washington University · Ellensburg, WABuilt 2020 · S/N 2881384 N548DSPullman Barrett · Corralitos, CABuilt 2001 · S/N 40048 N548EBRomeo Charlie Aircraft Partners LLC · North Little Rock, ARS/N 0291 N548PGStorey Kimberly · Middleton, IDBuilt 2008 · S/N 2005 N548PRFullin Daniel Creighton · Pleasant Prairie, WIBuilt 2020 · S/N 2584 N548RESabair LLC · Clinton, PABuilt 2025 · S/N 10969 N548SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881340 N548TRMauldin Air LLC · Lewes, DEBuilt 2006 · S/N 1743 N5499FIndy Air Sales LLC · Anderson, INS/N 28-7790127 N549CDValiair Limited Co Trustee · Casper, WYBuilt 2004 · S/N 1088 N549RJCynergy Cargo LLC · Douglas, GABuilt 2008 · S/N 4692099 N549SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881341 N549SRPlane Fun Flying Club · Vancouver, WABuilt 2006 · S/N 2177 N549WSBoraam Aviation Inc · Prospect Heights, ILBuilt 1997 · S/N 3246073 N54DLMorris Samuel A · Prineville, ORBuilt 1976 · S/N 28-7690213 N54DNBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2006 · S/N 1671 N54FAN54fa LLC · Pipersville, PABuilt 2024 · S/N 9885 N54KYGael Aviation Inc · West Harrison, NYBuilt 2015 · S/N 4207 N54LGSynergy Wellness Group Inc · Bakersfield, CABuilt 2007 · S/N 2685 N54LKJoppa Aviation LLC · Charlottesville, VABuilt 2005 · S/N 41533 N54LWDogtown Aviation LLC · Teton Village, WYBuilt 2007 · S/N 2407 N54PTMccall Transport LLC · Portland, ORS/N LW-331 N54RGRemc Leasing LLC · Bismarck, NDBuilt 2011 · S/N 4697478 N54SJBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2006 · S/N 1657 N54TKDlp Real Estate Capital Inc · Saint Augustine, FLBuilt 1980 · S/N BB-686 N54TSTs Aviation LLC · Farmingdale, NYBuilt 2025 · S/N 10797 N54TXBail Air LLC · Port Saint Lucie, FLBuilt 1977 · S/N 28-7890151 N54VL4791 Capital Holdings LLC · Austin, TXS/N 4791 N54WFMajmudar Krupal · Flemington, NJBuilt 2017 · S/N 4506 N54WTAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1999 · S/N 4636202 N5500XWehrs Aviation LLC · Oro Valley, AZBuilt 2006 · S/N 41602 N5504GRemoteguard Services LLC · Wildwood, MOS/N 28-8290068 N5506FShen Air II Inc · Mount Crawford, VAS/N 28-7790128 N550CADubin Donald · Salida, COBuilt 2018 · S/N 4636736 N550CDCoen Scott D · Kingsport, TNBuilt 2004 · S/N 1124 N550CRCwr Holdings LLC · Wilmington, DEBuilt 2001 · S/N 4697031 N550DDSaratoga Aviation LLC · Rocky Mount, NCBuilt 1996 · S/N 32-46037 N550GLGaba Zero Seven LLC · Beaumont, TXBuilt 1980 · S/N BB-781 N550JGNorby Aviation LLC · Hopkinton, MABuilt 2001 · S/N 1161 N550PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842106 N550RGBr Ventures LLC · Port Orange, FLBuilt 2005 · S/N 1635 N550STWilliston Basin Energy LLC · Bismarck, NDBuilt 1985 · S/N 348533008 N5513VRenaldo Michael T · Stafford, VABuilt 1977 · S/N 28-7716181 N551ATCorellian Spacecraft LLC · Leesburg, VABuilt 2021 · S/N 5149 N551BBMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881574 N551BPPalmer John Michael · Saint Louis, MOBuilt 2007 · S/N 2876 N551CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881513 N551CDBwr Group LLC · Hobbs, NMBuilt 2005 · S/N 1550 N551JLN551jl LLC · Greenville, SCBuilt 1980 · S/N BB-788

Back to AD 2008-06-28 R1