AD 80-25-07 R1
Registered aircraft · 25,364
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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.
N107RARl Aviation LLC · Miami, FLN107RCHat Creek Construction & Development Inc · Glennville, GAN107RFStevens Matthew S · Penn Yan, NYN107RHHenderson Robert T Jr · Sunny Isles Beach, FLN107SKFitzpatrick William M · Cleveland, GAN107TSSmith Terry G · Liberty Twp, OHN1080FWeitekamp Shawn Paul · Roanoke Rapids, NCN1080PN41723 Partners LLC · Vienna, WVN1082FWings Over Texas Holdings LLC · Denton, TXN1083EDavis Gregory P · Olathe, KSN1083FKellogg Gretchen Garst · Mesa, AZN1083LBenson Mark D · San Diego, CAN1084LMillet Alan E · Sequim, WAN1084VEastwind 9 LLC · Dover, DEN1085FSale Reported · Greenwood, INSale reported, pending cancellationN1085XCovington Guy P Sr · Centreville, MDN1086QBarnhardt Paul · Madison, GAN1086UHancock County Port & Harbor Commission · Kiln, MSN1088UWestern Wyoming Aviation Services LLC · Pinedale, WYN1089UJkg LLC · Murfreesboro, TNN108ATKirschner John R · Crystal Lake, ILN108EAArellano Erick C · Brownsville, TXN108HSContrails II Inc · Kerrville, TXN108JGStilts Steven · Houma, LAN108JMHarris Kenneth L · Greeley, CON108SUHardy James · Albany, NYN1090ECrouse John A · Sterling, AKN1090FIsley Jason T · Sand Springs, OKN1090PTidewater Express Ltd · Georgetown, DEN1091EGlatthaar Richard J · Burbank, WAN1091MSwaz Aviation LLC · Mesa, AZN1093EHanna Mark J · Orange, CAN1094FG&M Aircraft Inc · Wheat Ridge, CON1094UBrajnikoff Edward C · San Francisco, CAN1095EIndependent Dusting Service Inc · El Campo, TXN1095UMalahmeh Adel J · New Iberia, LAN1096UBraten Randall O · Cody, WYN1097MNunes Lindybergh Jr · Laporte, INN10987Andreassen Ray E · Delta Junction, AKN10989Rickert Randy M · Lehighton, PAN1098EKruse Robert M · Liberty, MON1098MBingham John R · Leawood, KSN1098UKane Patrick · Chicago, ILN10990Speed And Angels LLC · Dover, DEN109CFMarigi William Kihara · Worcester, MAN109FRWilson Ronald Earl · Sedona, AZN109JGGraham Field Ltd · Adams Mills, OHN109PCFort Wayne Aircraft LLC · Fort Wayne, INN10ADTeerlink Randall S · Hanover, VAN10BYKing Air LLC · Navasota, TX
Back to AD 80-25-07 R1