Skip to content

Registered aircraft · 26,231

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:94-05-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:94-05-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:94-05-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:94-05-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:94-05-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:94-05-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.

N401GTCastillo Giovanny G · Brodheadsville, PABuilt 1966 · S/N 17255188 N401XMills Charles K · Hernando, FLBuilt 2001 · S/N AV1066 N4020FBarnard David P · Delmar, NYBuilt 1958 · S/N 36920 N4020VDanielson Bradley M · Pelkie, MIBuilt 1975 · S/N 15076680 N4021JSharapan Ilya · Brooklyn, NYBuilt 1966 · S/N 15065321 N4021NBielecki Gerald M · Vero Beach, FLBuilt 1947 · S/N 13479 N4021VBeishline Daniel · Bath, MES/N 18340 N4022EGhl Air LLC · Ames, IABuilt 1947 · S/N 11BC-110 N4022NHazelton Carl R · Aransas Pass, TXBuilt 1947 · S/N 13480 N4023JHector Flyers LLC · Hector, MNBuilt 1966 · S/N 15065323 N4023NZembinski Robert · Brookfield, WIBuilt 1947 · S/N 13481 N4025FBrazos River Aviation Group LLC · Mineral Wells, TXBuilt 1958 · S/N 36925 N4025URichardson Richard A · Fort Worth, TXBuilt 1965 · S/N 15061425 N4026VLandry Timothy G · Lodi, CABuilt 1948 · S/N 18345 N40271Larson Jeffrey A · Eau Claire, WIS/N AV1062 N4027EGrimshaw Nicholas A · Galt, CABuilt 1947 · S/N 11BC-115 N4027JMcburney James H Jr · Horseshoe Bay, TXBuilt 1967 · S/N 15065327 N4027UTsukii Toshikazu · Tucson, AZBuilt 1965 · S/N 15061427 N4028JWarn James D Jr · Overland Park, KSBuilt 1966 · S/N 15065328 N4028NOast Thomas H · Sedan, KSBuilt 1947 · S/N 13621 N4028UCesperalle Aviation LLC · Grassy Butte, NDS/N 15061428 N4029Lutes Robert Trustee · New Paris, INBuilt 1971 · S/N W-1000 N4029FMcelhaney Jung R · Phelan, CABuilt 1958 · S/N 36929 N4029NRidgway Rick J · Carlisle, INBuilt 1947 · S/N 13487 N4029UPathfinder Aero Services LLC · Sheridan, WYS/N 15061429 N40316Kuper Richard J · Charleston, ARS/N 99 N4031EMathis Gary A · Gonvick, MNS/N 11BC-118 N4032FDmnm LLC · Albuquerque, NMBuilt 1958 · S/N 36932 N4032NHoward Nancy Jo · Elmore, OKBuilt 1947 · S/N 13490 N4032ULiberty University Inc · Lynchburg, VABuilt 1965 · S/N 15061432 N4032VHart Travis R · Ontario, ORBuilt 1948 · S/N 18351 N4033ECongdon Carl J · Manley, AKBuilt 1947 · S/N 11BC-121 N4033VJepsen James Scott · Kirkwood, MOBuilt 1948 · S/N 18380 N4034EAdams Thomas D · Marathon, NYBuilt 1947 · S/N 11BC-122 N4034JStange Robert C · Toledo, OHBuilt 1966 · S/N 15065334 N4035FGinn Ray Jr · Beeville, TXBuilt 1958 · S/N 36935 N4035JBloomquist Steven R · Granbury, TXS/N 15065335 N4035VBeckner Russell R · Rutland, MAS/N 18382 N4037FSicaras Paul G · Longmont, COBuilt 1958 · S/N 36937 N4037NRybarczyk Matt M · Rice Lake, WIBuilt 1947 · S/N 13495 N4037UDelgado Brandon · Moreno Valley, CABuilt 1965 · S/N 15061437 N4038ELerol Dustin C · Floodwood, MNBuilt 1947 · S/N 11BC-162 N4038FKcantarano LLC · Mukilteo, WABuilt 1958 · S/N 36938 N4038VStirling Nathan L · Alton, MEBuilt 1975 · S/N 15076682 N4039FBlue Ice Aviation Inc · Wasilla, AKS/N 36939 N4039NAdams Scott T · Phillips, MEBuilt 1947 · S/N 13497 N4039UHendrickson Flying Service Inc · Rochelle, ILBuilt 1965 · S/N 15061439 N4039VHowe Shawn E · Lewistown, PABuilt 1948 · S/N 18358 N4041UCumberland Soaring Group Inc · Wiley Ford, WVBuilt 1965 · S/N 15061441 N4042FTweedle Dee LLC · John Day, ORBuilt 1958 · S/N 36942

Back to AD 94-05-05 R1