Skip to content

Registered aircraft · 54,017

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N539MTFlyboys LLC · Fall City, WABuilt 1962 · S/N 17249604 N539PBHumphrey Daryle C · Graford, TXS/N 17264402 N53BWheaton James · Rutherfordton, NCBuilt 1953 · S/N 25995 N53ESSpooner Brent · Fulshear, TXS/N 30053 N53EURegistered aircraftBuilt 1973 · S/N 18262276 N53FBBiniewicz Frank B · Downers Grove, ILBuilt 1979 · S/N 17273291 N53JVan Way Dillion J · Lafayette, LABuilt 1979 · S/N 17272890 N53LDEnglish William · Fairfax, VAS/N 25599 N53MPPie In The Sky Inc · Shreveport, LABuilt 1969 · S/N 18260096 N53PHHaynes Jason Allen · Justin, TXS/N A1500352 N53PLPocquette Beau W · Deer River, MNBuilt 1976 · S/N R1722171 N53SGJecker Scott W · San Marcos, TXS/N 21062609 N53TMSmith Douglas M · Hackettstown, NJBuilt 1975 · S/N 21060762 N54003Albuquerque Aviation Academy · Albuquerque, NMBuilt 1981 · S/N 17274838 N54007Romey Samuel A · Ketchikan, AKBuilt 1980 · S/N 18504026 N5400BRegistered aircraftBuilt 1956 · S/N 33400 N5400HF & J Air LLC · Abbeville, SCBuilt 1975 · S/N 17265423 N5400JErwa Mohamed E · Leander, TXBuilt 1980 · S/N 17273780 N5400TDonnelly Charles R · Nashua, NHBuilt 1964 · S/N 17251300 N5400VWilson Darryl M · Granger, INFirst renewal noticeS/N 21060935 N54011United States Air Force (Owner) · Dover Afb, DEBuilt 1981 · S/N 17274842 N54012Carelli Alfred J · Ocala, FLBuilt 1981 · S/N 17274843 N54015Northwoods Air LLC · Orono, MEBuilt 1981 · S/N 17274845 N5401AHeadon Richard · Chino Hills, CABuilt 1979 · S/N 21063414 N5401HDms Leasing Company LLC · Las Vegas, NVBuilt 1975 · S/N 17265424 N5401NMcmanus Casey J · Edmonds, WABuilt 1980 · S/N 18267691 N5401QMaine Center For Classic Aviation · Pittsfield, MES/N 15073301 N5401XBarbera Frank M · Edgewood, NMBuilt 1980 · S/N U20605717 N5402AHodge Marcus · Mansfield, LABuilt 1985 · S/N P21000851 N5402BFiehler Vernon D · Auke Bay, AKBuilt 1956 · S/N 33402 N5402EOsprey Holding Company LLC · Foley, ALBuilt 1978 · S/N 17271845 N5402RBarsto Aviation Inc · Wilmington, DEBuilt 1974 · S/N 17263535 N54031Mlr Adventures Inc · Wilmington, DEBuilt 1981 · S/N 17274851 N54036Missions Unlimited Of Oregon Inc DBA · Harrah, OKBuilt 1981 · S/N 17274852 N5403EBuness Timothy A · Wrangell, AKBuilt 1979 · S/N 18503963 N5403HWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 15284096 N5403QAbriam Darryl · Dahlgren, VABuilt 1972 · S/N 15073303 N5403RPeterson Matthew · Overland Park, KSBuilt 1965 · S/N 17252941 N5403TIngrim William Paul · Girdwood, AKBuilt 1964 · S/N 17251303 N5403VL & R Consulting LLC · Las Vegas, NVBuilt 1980 · S/N 172RG0521 N54041Bowen John E · Ocala, FLBuilt 1981 · S/N 17274855 N54048Hodge Flight Services LLC · Pittsburgh, CABuilt 1981 · S/N 17274857 N54049Pittinger Mitchell J · Reisterstown, MDBuilt 1981 · S/N 17274858 N5404BRichmor Aviation Inc · Hudson, NYBuilt 1979 · S/N 15283862 N5404RKoller Rex E · Athens, ALS/N 17252942 N5404TCorrea Ruben D · Horn Lake, MSS/N 17251304 N5404WBas Part Sales LLC · Greeley, COBuilt 1981 · S/N P21000683 N5405AN5405a LLC · Beverly Hills, CABuilt 1985 · S/N P21000852 N5405BNatkat Aviation Services LLC · Finleyville, PABuilt 1979 · S/N 15283863 N5405CRegistered aircraftBuilt 1950 · S/N 19439

Back to AD 87-20-03 R2