AD 74-08-01
Registered aircraft · 10,878
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
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:74-08-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-08-01')
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:74-08-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-08-01') 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.
N104NPDv Aviation Inc · Brainerd, MNN104NRMiller Dale D · Eagle River, AKN104PSouthern Aircraft Consultancy Inc Trustee · Casper, WYN104PDBaumann James R · Muskogee, OKN104SPJanaitis Aviation LLC · Middletown, DEN104WMHamilton Aviation LLC · Morehead, KYN1050VState Of Wisconsin · Madison, WIN1051VSackett Ryan W · Anchorage, AKN1052MFendt Alan D Trustee · Dexter, MIN1055MRyan Michael W · Long Beach, CAN105CWStone George Michael Jr Trustee · Weeki Wachee, FLN105MTRegistered aircraftN105PDN105pd LLC · Ulysses, KSN1067MShore Enterprises Of Gainesville LLC · Gainesville, FLN1068MWolfenden Allen K · Rocklin, CAN106GCJones Michael D · Warner Robins, GAN106PSScarrow James D · Jerome, IDN1073MScr Aviation LLC · Austin, TXN1074TIowa Lakes Community College · Estherville, IAN1075MDewitt Scott C · Corpus Christi, TXFirst renewal noticeN1078MGeorge Gary D · Humble, TXN1079MGeneral Aviation LLC · Henderson, NVN107BLVinland Aerodrome Inc · Baldwin City, KSN107DBSkymaster Stc LLC · Mena, ARN107ESWalpole John W · Iola, TXN107JPPayne Thomas E · Old Forge, NYN107RARl Aviation LLC · Miami, FLN107RFStevens Matthew S · Penn Yan, NYN107SKFitzpatrick William M · Cleveland, GAN1085MDuncan Terry C Trustee · Cupertino, CAN1086MSargent John E · Vancouver, WAN1086UHancock County Port & Harbor Commission · Kiln, MSN1088UWestern Wyoming Aviation Services LLC · Pinedale, WYN1089MPetersen Clayton · Albert Lea, MNN1089UJkg LLC · Murfreesboro, TNN108ATKirschner John R · Crystal Lake, ILN108JMHarris Kenneth L · Greeley, CON1090MBergstrom Aircraft Inc · Pasco, WAN1091MSwaz Aviation LLC · Mesa, AZN1094UBrajnikoff Edward C · San Francisco, CAN1095UMalahmeh Adel J · New Iberia, LAN1096UBraten Randall O · Cody, WYN1097MNunes Lindybergh Jr · Laporte, INN1098MBingham John R · Leawood, KSN1098UKane Patrick · Chicago, ILN109CBSasser Edward Craig · Albemarle, NCN109RCLentfer Clinton H A · Anchorage, AKN109WYPerala Daniel R · Cheyenne, WYN10ETTech Nav LLC · Columbus, INN10FCKnott Me LLC · Phoenix, AZ
Back to AD 74-08-01