AD 79-10-14 R1
Registered aircraft · 56,582
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: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.
N9730VWings Over Texas Holdings LLC · Denton, TXN9730XHaase Herman · Stockton, CAN97311Christiansen Aviation LLC · Wilmington, DEN97313Civil Air Patrol Inc · Maxwell Afb, ALN9731ANorbury Frank R · Scottsdale, AZN9731FN9731f LLC · Stuart, FLN9731HCreative Strategies Inc · Proctorville, OHN9731TKarren Robert E · Mountain Home, IDN9731XPoe David A · Big Sandy, TXN9732AMoremen Joshua · Sagle, IDN9732GFulcher David B · Glendale, AZN9732HLand & Leave LLC · Helena, MTN9732VSiguaw Robert E · Deming, WAN9733GZimmitti Andrew · Mclean, VAN9733HStephens Jack J · Kingwood, TXN9733LStock Craig A · Devon, PAN9733VTyler Ronald J · Martville, NYN97345Postupack Peter Jr · New Cumberland, PAN9734AGreen Theodore G II · Burlington, WIN9734BPreston Aviation LLC · Henderson, KYN97358Rick Aviation Inc · Newport News, VAN9735XPascal LLC · Des Moines, WAN97361Sky 4 Me LLC · Greendale, WIN97365Sugg Robert Michael · Covington, GAN9736BWrigley David C · Anchorage, AKN9736GBrakey Richard F · Amarillo, TXN9736HBrentco Aerial Patrol Inc · Canton, OHN9736MRyan Air Inc · Anchorage, AKN9737GZamoruev Alexander Vladimirovich Trustee · Anchorage, AKN9737HXyz Aviation LLC · Rineyville, KYN9737VAero Equities LLC · Ventura, CAN97380Rsf Services LLC · Salem, ORN97385182q LLC · Tyler, TXN97386Ratcliffe & Sons Inc · Madill, OKN9738ADemio Douglas · Westbrook, CTN9738HBallard Bradley J · Youngsville, NCN9738XAdelman Timothy B · Stevensville, MDN97396Sds Aviation Inc · Buford, GAN97398Dbat Flying Club LLC · Reno, NVN9739GBjork Richard J · Brackettville, TXN973BCBattle Creek Flyers LLC · Battle Creek, MIN973EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN973HAAb Prop Plane I LLC · Metairie, LAN973JMMarc Inc · Bolton, MSN973KGRichard Mervin J Jr · Washington, DCN973SRRegistration Pending · Kuna, IDRegistration pendingN973WDBaggenstoss William J · Weiser, IDN9740GKestrel Kat LLC · Wilmington, DEN97410Skynuke LLC · Bechtelsville, PAN97413Northwoods Air LLC · Orono, ME
Back to AD 79-10-14 R1