Skip to content

Registered aircraft · 56,580

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N4156FPintar Robert · Spokane, WAS/N 46056 N4156GSan Diego Community College District · San Diego, CAS/N 15078862 N4156LZimmer Marc R · Moses Lake, WABuilt 1966 · S/N 17254225 N4157FBeasley John V III · Amarillo, TXS/N 46057 N4157VMoran Charles L Jr · Fresno, CABuilt 1948 · S/N 18489 N4158FKraft Dean B · Mapleton, NDBuilt 1958 · S/N 46058 N4159LGrassetti Raymond J · Monson, MABuilt 1966 · S/N 17254228 N4159UTodhunter John S · Hemet, CABuilt 1963 · S/N 15060159 N415LEStadelman Edwin F · East Falmouth, MABuilt 1999 · S/N 20608042 N415RCAvco Patrol LLC · Lyndon, KSBuilt 1998 · S/N 18280302 N415RJAviation Training LLC · Wilmington, DEBuilt 2005 · S/N 172S9943 N415SPAmeriflyers Of Texas Inc · Addison, TXBuilt 1999 · S/N 172S8346 N415SVPoytress Earl F Jr · Montrose, COBuilt 1969 · S/N 337-1135 N4161FGilbertson Daniel E · Duluth, MNBuilt 1958 · S/N 46061 N4161LBruner Harvey L · Latexo, TXBuilt 1966 · S/N 17254230 N4162FPowell Clinton J · Pleasanton, TXBuilt 1958 · S/N 46062 N4162UGiammarino Brian L · Antrim, NHBuilt 1963 · S/N 15060162 N4162VUntiet Steven R · Homer, AKBuilt 1950 · S/N 18494 N4163LLeitzman Robert A · Tucson, AZBuilt 1966 · S/N 17254232 N4163UWilson Jim A · Grand Rapids, MNBuilt 1963 · S/N 15060163 N4163VRoot Shane G · Dighton, KSBuilt 1948 · S/N 18495 N4164LDerwin Diversified Inc · Santa Paula, CABuilt 1966 · S/N 17254233 N4164URogers Robert P · Dubuque, IABuilt 1963 · S/N 15060164 N4164VRowe Dennis A · Vandergrift, PABuilt 1948 · S/N 18497 N4165VHagen Curt L · Sullivan, WIBuilt 1948 · S/N 18498 N4166LWarbelows Air Ventures · Fairbanks, AKBuilt 1966 · S/N 17254235 N4166VFreitas Anthony F · Canby, ORBuilt 1948 · S/N 18499 N4167FHamburg Jeffrey B · Warner Robins, GABuilt 1958 · S/N 46067 N4167URegistered aircraftS/N 15060167 N4168FOfarrell Leo S · Lakeport, CABuilt 1958 · S/N 46068 N4168LRoberts James E · Golconda, ILBuilt 1966 · S/N 17254237 N4168VLehr F Mark · Placitas, NMBuilt 1948 · S/N 18501 N4169ULofstrom David J · Chugiak, AKS/N 15060169 N4169YVanderhoof Chad T · Elk, WAS/N 185-0369 N416CPChristiansen Aviation LLC · Wilmington, DEBuilt 2020 · S/N 172S12504 N416CSTextron Aviation Inc · Wichita, KSBuilt 2016 · S/N 18282416 N416DCWeaver Eric W · Anchorage, AKBuilt 1959 · S/N 55940 N416FRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11444 N416SPRegistered aircraftBuilt 2000 · S/N 172S8349 N416WREagle Flying Club Of Embry-Riddle Aero Univ Inc · Daytona Beach, FLBuilt 2002 · S/N 172S9160 N416WTHigh Desert Flight Instruction LLC · Albuquerque, NMBuilt 1975 · S/N 17702355 N4170BOutman William D · Half Moon Bay, CABuilt 1953 · S/N 26137 N4170USwan Guy · West Palm Beach, FLBuilt 1963 · S/N 15060170 N4171LFleeman Danny W · Manila, ARBuilt 1966 · S/N 17254240 N4172FEdwon Ronnie L · Mesa, AZBuilt 1958 · S/N 46072 N4172PDmac Aircraft LLC · Savannah, GABuilt 1997 · S/N 17280288 N4172VMd Aero LLC · Somerton, AZBuilt 1948 · S/N 18505 N4173VLohmeier George A · Indianapolis, INBuilt 1948 · S/N 18506 N4175FGay Clayton B · Villisca, IAFirst renewal noticeBuilt 1958 · S/N 46075 N4175LColangelo Frank · New Preston, CTBuilt 1966 · S/N 17254244

Back to AD 79-10-14 R1