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.

N7796YWiederkehr William D · Palmer, AKBuilt 1966 · S/N 18-8409 N7797BWaggood Clayton R · Anchorage, AKBuilt 1955 · S/N 18-4449 N7797KScootair LLC · Alburgh, VTBuilt 1951 · S/N 20-614 N7797ZMiller Andy D · Marana, AZS/N 25-3999 N7798BBrown Hector M · Glenwood Springs, COBuilt 1955 · S/N 18-445 N7799DParkerson Stan L · Fairbanks, AKBuilt 1957 · S/N 18-6008 N7799KPatterson John S · Edgemont, ARBuilt 1951 · S/N 20-628 N7799ZMid Atlantic Soaring Association · Frederick, MDBuilt 1966 · S/N 25-4002 N77DWTop Flight Detail LLC · Middlebury, INBuilt 1949 · S/N 16-287 N77ECPederson Roland · Circle, MTBuilt 1941 · S/N 7025 N77GParker Ray W · Nome, AKS/N 22-1210 N77JGGoon Aviation LLC · Kalispell, MTBuilt 1978 · S/N 18-7809132 N77KFEischens Kolton S · Wasilla, AKS/N 18-7609124 N77PLVrooman Lawrence M · Winterville, NCBuilt 1957 · S/N 225793 N77STJb Ag Service LLC · Colstrip, MTBuilt 1959 · S/N 18-6738 N77YMNew Richard A · Deming, WABuilt 1957 · S/N 185832 N7800DGoff Harold G · Brandon, FLS/N 22-5444 N7801DWebb John M · Chugiak, AKBuilt 1957 · S/N 22-5445 N7801HSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1946 · S/N 12-698 N7803DFako John · Binghamton, NYS/N 22-5447 N7803FKarlovich James W · Kingston, GABuilt 1957 · S/N 18-6259 N7804DSchneider Kenneth H · Newark Valley, NYBuilt 1957 · S/N 22-5448 N7805DMoretti Anthony · Deming, NMBuilt 1957 · S/N 22-5450 N7806DHillegeist Tracy L · Beverly, KSS/N 22-5453 N7808ZWiedeman Matthew A · Batesville, INBuilt 1966 · S/N 18-8485 N7810DPetro Jerry R · Williamsburg, VABuilt 1957 · S/N 22-5456 N7811BThomason David C · Olathe, KSBuilt 1952 · S/N 20-808 N7811DGardner Thomas R · Summerville, SCBuilt 1957 · S/N 22-5457 N7811HCatto Air LLC · Jackson, CABuilt 1946 · S/N 12-715 N7813DBurkhart Galen L · Portland, ORFirst renewal noticeBuilt 1957 · S/N 22-5459 N7813HBevan John E · Spokane, WAFirst renewal noticeS/N 12-711 N7817DRike James O · Kittery Point, MEBuilt 1957 · S/N 22-5463 N7817HHalunen Arlie John Jr · Naples, NYBuilt 1946 · S/N 12-713 N7818HWest Stephen T · Chapel Hill, NCBuilt 1946 · S/N 12-716 N7822DTwinco Leasing LLC · Yacolt, WABuilt 1957 · S/N 22-5468 N7823BBombardo Joseph V · Clermont, FLBuilt 1953 · S/N 20-1048 N7823DBurnopp Jacob A · Evington, VABuilt 1957 · S/N 22-5469 N7823HCharley Arrie · Gakona, AKBuilt 1946 · S/N 12-723 N7824DWhitaker Samuel M · Brooklet, GABuilt 1957 · S/N 22-5470 N7827DThree Legged Hog Aviation LLC · Boise, IDBuilt 1957 · S/N 22-5473 N7828DDyer Royal J · Melrose, NYBuilt 1957 · S/N 22-5474 N7829HGardom Brandon D · Spirit Lake, IDBuilt 1946 · S/N 12-729 N7832DCamp Barry G · Lafayette, LAS/N 22-5478 N7834HWilde Air Service-Huron LLC · Volga, SDBuilt 1946 · S/N 12-734 N7837HCounsell Michael J · Moses Lake, WABuilt 1946 · S/N 12-737 N7839DMartin David · Jackson, GABuilt 1957 · S/N 22-5489 N783LKPullis Troy K · Hutchinson, MNBuilt 1959 · S/N 22-6900 N7840DDavis Steven T · Colleyville, TXBuilt 1957 · S/N 22-5490 N7841HCross Thomas Ad · Yacolt, WABuilt 1946 · S/N 12-741 N7842DCasler Robert A · Phelps, NYBuilt 1957 · S/N 22-5492

Back to AD 99-01-05 R1