Skip to content

Registered aircraft · 47,142

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

N115MMGunner The Red Baron LLC · Palm Desert, CABuilt 2021 · S/N 4997 N115MRRussell Keith M · Ivoryton, CTBuilt 1960 · S/N D-6394 N115NJUsda Forest Service Fepp · Trenton, NJBuilt 1966 · S/N 18256954 N115SDSky High Aviation LLC · Max, NDBuilt 1980 · S/N 250369 N115SPMinnesota State Patrol · Saint Paul, MNBuilt 2016 · S/N 4385 N115WDWalton Paul L · Indianapolis, INBuilt 1972 · S/N TE-863 N115YPIaba LLC · Norfolk, VAS/N L2K 143 N1161BDean William R · Webster Springs, WVBuilt 1982 · S/N 25-0661 N1161MRed Climb Transition LLC · New York, NYBuilt 1982 · S/N 25-0657 N1161PN1161p LLC · Aspen, COBuilt 1982 · S/N 25-0658 N1162DUniversal Pacific Investments Corp · Portland, ORBuilt 1983 · S/N 25-0730 N1162XSeeding Operations And Atmospheric Reseach LLC · San Angelo, TXBuilt 1975 · S/N 34-7570225 N1163ADodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 25-0666 N1163BCeltic Aviation LLC · Kalispell, MTBuilt 1982 · S/N 25-0667 N1163TIrish Aviation Inc · Orlando, FLBuilt 1975 · S/N TE-1033 N1164GGolonka Bryan · Locust Grove, GABuilt 1982 · S/N 25-0677 N1164WBeaver Brook Aviation LLC · Scotia, NYBuilt 1967 · S/N TE-400 N1165DFlight Management Group LLC · Wadsworth, OHBuilt 1981 · S/N 25-0640 N1165GBreason Enterprises LLC · Dover, DEBuilt 1982 · S/N 25-0685 N1165MArsene Eddy R · Lynnwood, WAS/N 18264237 N1165TFlying J Partners Asset Management LLC · Casper, WYBuilt 1975 · S/N D-9754 N11669Cummings Arthur · Delta Junction, AKBuilt 1963 · S/N 185-0493 N1166DQba LLC · Poway, CABuilt 1983 · S/N 25-0720 N1166MWarren Gregory C · Redmond, ORBuilt 1975 · S/N 18264238 N1166VClark John A · Windsor, CABuilt 1976 · S/N R1722130 N1166XEagle Aviation Inc · Tucson, AZBuilt 1975 · S/N 34-7570227 N1167HDawson Ron Jr · Garland, TXBuilt 1982 · S/N 25-0689 N1167JBas Part Sales LLC · Greeley, COS/N 25-0690 N1167NB52 Transports LLC · Altha, FLBuilt 1982 · S/N 25-0691 N1167UJohnson Thomas H · Garden City, UTBuilt 1982 · S/N 25-0692 N1167VBoard David N · Woodsfield, OHBuilt 1976 · S/N R1722131 N1167YShrestha Yuwaraj · Wichita, KSBuilt 1982 · S/N 25-0684 N1168BVitti Tyler · Ridgecrest, CABuilt 1982 · S/N 24-1303 N1168NCheung H Michael · Hudson, OHBuilt 1982 · S/N 25-0719 N1168SCnv Consulting LLC · West Jordan, UTBuilt 1982 · S/N 25-0694 N1168TKnight Oil Resources Inc · New Orleans, LABuilt 1975 · S/N TE-1045 N1168VGood Guys Flying Club LLC · Colorado Springs, COBuilt 1976 · S/N R1722132 N1168YRocking Jo Ranch Inc · Idaho Falls, IDBuilt 1982 · S/N 25-0696 N1169LGodwin Gerald R · Kountze, TXBuilt 1982 · S/N 25-0701 N1169QRohde Allen G · Eagle River, AKBuilt 1977 · S/N 18503466 N1169TMorin Daniel P · New Harbor, MEBuilt 1975 · S/N D-9770 N116ABHaller Phillip · Peoria, AZBuilt 1973 · S/N TE-899 N116ACRogue Aviation II LLC · Ladera Ranch, CABuilt 2023 · S/N 9346 N116AHRegistered aircraftBuilt 1981 · S/N 18267966 N116AKLucas Kelly W · Wasilla, AKBuilt 1965 · S/N 18051469 N116BDTxbd Investments LLC · Addison, TXBuilt 2002 · S/N E-3454 N116BGGood Bill T · Temecula, CABuilt 1955 · S/N 35116 N116DERiver Bay Aviation Sr22t LLC · Jacksonville, FLBuilt 2019 · S/N 1934 N116EALewistown Aviation Inc · Lewistown, PABuilt 1979 · S/N 340A0750 N116FTGreenhill Stacey · Lincolnshire, ILBuilt 2008 · S/N 411112

Back to AD 2000-23-21