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.

N3575KN83993 LLC · Cherry Hill, NJS/N 32R-8013037 N3575UJ P Aviation LLC · Kingfisher, OKBuilt 1979 · S/N 28-8090198 N3575XSmith Foster Fritz · Bishopville, SCBuilt 1979 · S/N 28-8090199 N3576HJohnson Grant J · Doylestown, PABuilt 1979 · S/N 28-8090205 N3576JStephens Lloyd G · Saratoga, CABuilt 1979 · S/N 28-8090206 N3576MFly Legacy Planes LLC · Philadelphia, PABuilt 1978 · S/N 28-7890315 N3576RDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1979 · S/N 28-8090207 N3576XField Aviation LLC · Fairview, TXBuilt 1979 · S/N 32R-8029035 N3577DAga Aviation LLC · Lewes, DEBuilt 1979 · S/N 32R-8029036 N35789Barrett Robin C · Holwaloa, HIBuilt 1979 · S/N 28-8016230 N3579QSchwartz Douglas · Plymouth, MIBuilt 1979 · S/N 32R-8029039 N357BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2025 · S/N 2881912 N357CDNo Fear Aviation LLC · Madison, WIBuilt 2025 · S/N 10793 N357CFCoast Flight Training And Management Inc · San Diego, CABuilt 1979 · S/N 447995091 N357ERoss Modglin · Sandy Valley, NVS/N 0650 N357GAOhm Aviation LLC · Merion Station, PABuilt 2010 · S/N 2070 N357GKGk Aviation LLC · Orlando, FLBuilt 2024 · S/N 10140 N357JAEagle Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020077 N357MKNorth Star Aviation · Mankato, MNBuilt 2022 · S/N 2881523 N357PPaphos Airways LLC · Farmingdale, NYBuilt 1977 · S/N 28-7816005 N357SBPistachio Holdings LLC · Miami, FLBuilt 2020 · S/N 2539 N357X3jc LLC · Phoenix, AZBuilt 2002 · S/N 1227 N358BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881806 N358CAFreeman Braxton L · West Lebanon, NHBuilt 1989 · S/N 2841283 N358CDOptimal Aircraft Management Mi LLC · Sanford, MIBuilt 2004 · S/N 0967 N358CFApm Leasing LLC · Casper, WYBuilt 1978 · S/N 44-7995115 N358DMTampa Maule LLC · Tampa, FLBuilt 2006 · S/N 42548 N358GAtp Taa LLC · Wilmington, DEBuilt 2020 · S/N 2881428 N358MKNorth Star Aviation · Mankato, MNBuilt 2022 · S/N 2881524 N358MMBentrup Reinhard F · Goleta, CABuilt 2008 · S/N 4697352 N358PKMajor John A · Kerrville, TXBuilt 2022 · S/N 8631 N358TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881858 N358TPCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11648 N358WAWestern Aircraft Inc · Boise, IDBuilt 2025 · S/N 4636869 N359BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881807 N359CDKomet Israel · Midland, MIBuilt 2004 · S/N 1184 N359CMCm Flyers LLC · Wayland, IABuilt 2016 · S/N 4434 N359FAStratus Rr LLC · New Castle, DEBuilt 2022 · S/N 28020059 N359LULewis University · Romeoville, ILBuilt 2025 · S/N 4496596 N359NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881658 N359SMod Eleven LLC · Los Alamos, NMBuilt 2001 · S/N 0072 N359STN921rt LLC · Lithia, FLBuilt 2025 · S/N 4636859 N359VMAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2015 · S/N 4636679 N359WYParadise Flyers LLC · Cudjoe Key, FLBuilt 2014 · S/N 2249 N35CMHorseshoe Air LLC · Fairfield, TXBuilt 2016 · S/N 4636708 N35CVNavajo Enterprises LLC · Schwenksville, PABuilt 1977 · S/N LW-252 N35ECKoda Bear Properties LLC · Wilmington, DEBuilt 2004 · S/N 0883 N35GGWilforge LLC · Phoenix, AZBuilt 1999 · S/N 4636207 N35GHPiper Aircraft Inc · Vero Beach, FLS/N 4636880 N35GKPacific Flight Aviation LLC · Costa Mesa, CAS/N 3449174

Back to AD 2008-06-28 R1