Skip to content

Registered aircraft · 10,639

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:99-01-05-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:99-01-05-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:99-01-05-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:99-01-05-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:99-01-05-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:99-01-05-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.

N4593MSmith Terry G · Wallowa, ORBuilt 1947 · S/N 1196 N4593YSoaring Society Of Boulder · Boulder, COBuilt 1967 · S/N 25-4278 N4594HLund John G · Cadillac, MIBuilt 1948 · S/N 17-12 N4594MPilster Ranch Corp · Alzada, MTBuilt 1947 · S/N 11-97 N4594ZRichard Waldren LLC · Newberg, ORBuilt 1961 · S/N 22-8104 N4595HBranagh Charles · Clay, NYBuilt 1948 · S/N 17-13 N4595MCubswift LLC · San Antonio, TXBuilt 1947 · S/N 11-98 N4596HAzevedo Manuel J · Modesto, CABuilt 1948 · S/N 17-14 N4596MKoshman Kyle A · Pleasant Grove, CAS/N 11-99 N4596ZEscue Dean · Milford, NJBuilt 1961 · S/N 22-8106 N4597MDoherty Michael J · Le Sueur, MNBuilt 1947 · S/N 11-100 N4597ZEgan Richard G · Tallahassee, FLBuilt 1961 · S/N 22-8109 N45PCEllis Kirk W · Gakona, AKBuilt 1955 · S/N 22-3145 N45TDDiers Robert D · Fremont, NEBuilt 1960 · S/N 18-7270 N4600HWilson William H · Iron Station, NCBuilt 1948 · S/N 17-17 N4600MCates Hubert R · Tallula, ILBuilt 1947 · S/N 11-103 N4601HDaniel Quinton L · Vicksburg, MIBuilt 1948 · S/N 17-18 N4602MShrader Stephen D · Anchorage, AKFirst renewal noticeBuilt 1947 · S/N 11-106 N4602ZMoorefield Oscar W · Monroe, GABuilt 1961 · S/N 22-8116 N4603ZN4603z Colt Flyers LLC · Kenmore, WAS/N 22-8117 N4604HGalegor Samuel T Jr · Peculiar, MOS/N 15-358 N4604MHayton James B · Sedro Woolley, WAS/N 11-108 N4605HFenstermacher Robert B · Telford, PABuilt 1948 · S/N 17-21 N4606MBischoff Roy H III · Flower Mound, TXS/N 11-110 N4606YAdirondack Soaring Association Inc · Ballston Spa, NYBuilt 1967 · S/N 25-4303 N4610HDuck Donald E · Edwardsburg, MIBuilt 1948 · S/N 17-27 N4610MWolf Run Aviation LLC · Whitefish, MTBuilt 1947 · S/N 11-114 N4610YPanama City Cycles Inc · Panama City, FLBuilt 1971 · S/N 18-8940 N4610ZGrantham Farley · Bush, LAS/N 22-8124 N4611ZRichard Waldren LLC · Newberg, ORFirst renewal noticeBuilt 1961 · S/N 22-8125 N4612HHudgin James P · Murfreesboro, TNBuilt 1948 · S/N 17-29 N4612YGrasshopper Aviation LLC · Tulsa, OKBuilt 1971 · S/N 18-8933 N4615HStahl John R · Union Dale, PAFirst renewal noticeBuilt 1948 · S/N 1732 N4615MHistoric Aircraft Restoration Museum · Saint Louis, MOBuilt 1947 · S/N 11-119 N4615YCherry Hill Flying Club LLC · Freetown, INS/N 18-8936 N4616HMoore Thomas R · North Bay, NYBuilt 1948 · S/N 17-33 N4616MDanielski Donald K · Valentine, NEBuilt 1947 · S/N 11-120 N4616YEugene F Burrill Lumber Co · Medford, ORBuilt 1971 · S/N 18-8941 N4616ZBest David Eugene · Newalla, OKBuilt 1961 · S/N 22-8130 N4617HRegistered aircraftBuilt 1948 · S/N 17-34 N4618HMeadows Joseph T · Charleston, TNBuilt 1948 · S/N 17-35 N4618YEagleville Soaring Club · Eagleville, TNBuilt 1967 · S/N 25-4324 N4618ZFilhart Robert · Rosebush, MIBuilt 1961 · S/N 22-8132 N4619HFaulkner Ronnie L · Cocoa, FLBuilt 1948 · S/N 17-36 N4619ZUnlimited Aviation Services LLC · Olympia, WAS/N 15-251 N461PMMcmillion John T Trustee · Grand Marais, MNBuilt 1946 · S/N 12-461 N4620HMay Kenneth D Sr · Sandy Hook, MSFirst renewal noticeBuilt 1948 · S/N 15-359 N4620MGatten Brett L · Wasilla, AKS/N 11-124 N4621HRegistration Pending · Havensville, KSRegistration pendingBuilt 1948 · S/N 17-37 N4621ZGodbold Donald W · Camden, ALBuilt 1961 · S/N 22-8136

Back to AD 99-01-05 R1