Skip to content

Registered aircraft · 6,349

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

N971SASuccess Aviation · Arcola, TXFirst renewal noticeBuilt 1996 · S/N 200022 N9723UFields Troy A · Nashville, TNS/N AA1C0106 N972GLWelch Gary A · Groveland, CABuilt 2016 · S/N 6-8947 N9733ACloud Dancer Aviation Inc · Deland, FLBuilt 1978 · S/N 15281329 N9737TBayview Flying Club LLC · Milwaukee, WIFirst renewal noticeBuilt 1978 · S/N 38-78A0177 N9738ULindstrom Richard T · Castro Valley, CAS/N AA1C0111 N9739UFortnight Aviation LLC · Philadelphia, PABuilt 1977 · S/N AA1C0112 N973BWBattle Flag Inc · Wilmington, DEBuilt 1997 · S/N 1361-97 N9741TLitchfield Flying Club Inc · Litchfield, MNBuilt 1978 · S/N 38-78A0181 N9757TDevevo Warren C Sr · Sylvania, GABuilt 1978 · S/N 38-78A0189 N9763TBiotech Vending LLC · Escondido, CABuilt 1978 · S/N 38-78A0192 N9771TTrevisan Hugo S · Polk City, FLS/N 38-78A0200 N9775TDawson John D · Garland, TXBuilt 1978 · S/N 38-78A0203 N9782UHull Michael J · Easley, SCBuilt 1977 · S/N AA1C0117 N9786UAngenend Kevin · Beaumont, TXBuilt 1978 · S/N AA1C0125 N9792UAim 54 Aviation LLC · Rock Hill, SCBuilt 1978 · S/N AA1C0127 N979SBickers Kevin T · Tehachapi, CABuilt 1980 · S/N J176009R N97BTMccullagh John A · Sugar Land, TXBuilt 1998 · S/N AV1075 N97LZZwijacz Michael F · South Lake Tahoe, CABuilt 1997 · S/N 000197 N9805UIsbell Richard M · Denton, TXBuilt 1978 · S/N AA1C0131 N980NOneill Aviation LLC · Lake Wales, FLS/N A1520814 N9811TAnywhere Atp LLC · Mount Juliet, TNBuilt 1978 · S/N 38-78A0213 N98197Barnes Bryce S · East Jordan, MIBuilt 1946 · S/N 18358 N982GCollester Rodney D · Danville, INBuilt 1967 · S/N 7ECA-321 N982WKnox Warren Henry · Santa Cruz, CABuilt 1962 · S/N 22-9219 N9831UJaggers Aviation LLC · Tupelo, MSS/N AA1C0139 N9832UMadison Harvey H · Lubbock, TXBuilt 1978 · S/N AA1C0140 N9841UJohnson Jeffery · Floydada, TXBuilt 1978 · S/N AA1C0141 N9842THahn John C · Sherwood, ARBuilt 1978 · S/N 38-78A0223 N9847UIke Andrew · Twin City, GABuilt 1978 · S/N AA1C0142 N984WBRichard Waldren LLC · Newberg, ORBuilt 1961 · S/N 22-8398 N9858LAnkney Gary L · Rector, PABuilt 1974 · S/N AA1B-0458 N9859UNorth Chet B · Spring Hill, KSBuilt 1978 · S/N AA1C0146 N98606Fawcett Walter L Jr · Wolfeboro, NHBuilt 1946 · S/N 18828 N9862UFearn Mickey M · Idaho Falls, IDBuilt 1978 · S/N AA1C0147 N9865LCox Justin E · Albuquerque, NMBuilt 1974 · S/N AA1B-0465 N9866UFell Vincent · Lubbock, TXBuilt 1977 · S/N AA1C-0065 N9867LHubbard Christopher Thomas · Myrtle Beach, SCBuilt 1974 · S/N AA1B-0467 N9870LFullerton John N · Corpus Christi, TXBuilt 1974 · S/N AA1B-0470 N9871LKamen Benjamin · Champaign, ILBuilt 1974 · S/N AA1B-0471 N9873TMaycock David V · Hurricane, UTBuilt 1978 · S/N 38-78A0227 N9877LMckinley Matthew · Sault Sainte Marie, MIBuilt 1974 · S/N AA1B-0477 N9878LBachman Aviation Inc · Winter Haven, FLBuilt 1975 · S/N AA1B-0478 N987BWWeber Wayne W · Morgan, MNBuilt 1988 · S/N 764 N9880HAbell Alan R · Elgin, ILBuilt 1943 · S/N 51434 N9880LTrinity Property Management LLC · Corvallis, ORBuilt 1974 · S/N AA1B-0480 N9881LFerrell D R · Stockton, CAS/N AA1B-0481 N9883UPars Avn Corp · Wilmington, DEBuilt 1978 · S/N AA1C0148 N9884LGaston Stephen J · Saint James City, FLBuilt 1974 · S/N AA1B-0484 N98875Breun David J · Albuquerque, NMS/N 19135

Back to AD 80-25-02 R2