Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N257RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266240 N257TATextron Aviation Inc · Wichita, KSS/N 172S13615 N2581YOverman Aviation LLC · Saint Louis, MOS/N 17249881 N2582LRichardson Michael Todd · Wilkesboro, NCS/N 17255782 N2583LMontgomery Robert A · Hampstead, NCBuilt 1967 · S/N 17255783 N2583UUfly Vi LLC · St Thomas, VIBuilt 1963 · S/N 17250183 N2584URedd David C · Blanding, UTBuilt 1963 · S/N 17250184 N2585LAerospace Quality LLC · Piggott, ARS/N 17255785 N2585ULionudakis Michael A · Scotts Valley, CABuilt 1963 · S/N 17250185 N2586LRuiz Edinson · Bakersfield, CABuilt 1967 · S/N 17255786 N2586SCasey Aviation Inc · Mansfield, MAS/N 17252809 N2586UMaynor Roy · Brazoria, TXS/N 17250186 N2587UEt Flight LLC · Cedar Park, TXBuilt 1963 · S/N 17250187 N2589YOrtner Airport LLC · Wakeman, OHBuilt 1962 · S/N 17249889 N258BWEastern Kentucky University · Richmond, KYBuilt 1981 · S/N 17274811 N258EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13334 N258ERLewis Carlos Brandon · Indian Mound, TNBuilt 1978 · S/N 17270891 N258MAJ Linn Aviation Inc · Quinlan, TXS/N 17269926 N258RAReynolds Darryl G · Wills Point, TXBuilt 1978 · S/N 17270533 N2591LHettenbach Paul A · Carrollton, TXBuilt 1967 · S/N 17255791 N2593LDaly Moses M · Underhill, VTBuilt 1967 · S/N 17255793 N2593UCamara Cesar David · Plumas Lake, CABuilt 1963 · S/N 17250193 N2594LSheldon Paul T · Saint James, MNBuilt 1967 · S/N 17255794 N2594YBruns John R Jr Trustee · Floyds Knobs, INBuilt 1963 · S/N 17249894 N2595LPiper Capital Growth Fund LLC · Scottsdale, AZBuilt 1967 · S/N 17255795 N2595UHare Sidney Wiggins · Roanoke, ALBuilt 1963 · S/N 17250195 N2595YRenco Angelo · Oceanside, CAFirst renewal noticeBuilt 1962 · S/N 17249895 N2596LBurris Cale · Hardin, ILBuilt 1967 · S/N 17255796 N2598YHarding William R Jr · Quinlan, TXBuilt 1963 · S/N 17249898 N2599YTalmadge Robert E · Vero Beach, FLBuilt 1962 · S/N 17249899 N259BDRainier Flight Service LLC · Renton, WABuilt 2025 · S/N 172S13356 N259EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13335 N259GFPerformance Aircraft Sales Inc · Lincoln, NEBuilt 1997 · S/N 17280259 N259JSCrystal Coast Training LLC · Kinston, NCBuilt 2023 · S/N 172S13012 N259RAReynolds Darryl G · Wills Point, TXBuilt 1998 · S/N 17280444 N259SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13404 N259TATextron Aviation Inc · Wichita, KSS/N 172S13618 N25BQAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13218 N25CWSpartan Education LLC · Tulsa, OKBuilt 2005 · S/N 172S9875 N25ESGeneral Aviation Support Corp · Rosamond, CABuilt 1977 · S/N 17269082 N25SKH & H Aviation Enteprises LLC · Fairfield, OHBuilt 1979 · S/N 17273152 N2600ATextron Aviation Inc · Wichita, KSS/N 172S13633 N2600LN2600l LLC · Pageland, SCBuilt 1967 · S/N 17255800 N26010Career Track 3 LLC · Wilmington, DEBuilt 2026 · S/N 172S13477 N26011Career Track 5 LLC · Wilmington, DEBuilt 2026 · S/N 172S13496 N26012Career Track 5 LLC · Wilmington, DEBuilt 2026 · S/N 172S13502 N26013Career Track 5 LLC · Wilmington, DEBuilt 2026 · S/N 172S13505 N26014Career Track 5 LLC · Wilmington, DEBuilt 2026 · S/N 172S13535 N2601LCobb William J · Cincinnatus, NYBuilt 1967 · S/N 17255801 N2601UK D Helicopters Inc · Shingleton, MIBuilt 1963 · S/N 17250201

Back to AD 90-06-03 R1