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.
N7136QPa Lawrence LLC · Anchorage, AKN7136SGonzalez Alec · Homestead, FLN7136TSnouffer Robert E · Mountain Grove, MON7136XArchangel Michael Flyers Inc · Princeville, HIN71374Farmers Supply Corp · Ontario, ORN71378Hanson Jared E · Missoula, MTN7137ACarrico Drew E · Redway, CAN7137ESss Inc · Anchorage, AKN7137TLeavitt John E · Palmer, AKN71384Neal Donald L · Fresno, CAN71386Single Engine Flyers LLC · Fredericksburg, TXN7138GWerenko Zandra · Cape Canaveral, FLN7138QArctic Aviation Leasing LLC · Anchorage, AKN7138SDeaton Craig · West Alexandria, OHN7138THudson Thomas C · Bessemer, ALN7138XHalvorson Jerome B · Wyndmere, NDN71397Turner Chris · Kosse, TXN71398Koch Jon P · Menahga, MNN7139ATimothy Scott Bloom · Chugiak, AKN7139DBenjamin Ralph L · Fitchburg, WIN7139EBarnes Gary · Idaho City, IDN7139GSkysg LLC · Eugene, ORN7139QFernander David · Enterprise, ALN7139XBryk Steven L · Port Orange, FLN713ADSchuessler William · Turner, ORN713BJRiley James A · Richmond, KYN713CPCivil Air Patrol · Maxwell Afb, ALN713DJimmy & Steve Aviation LLC · Fredericksburg, VAN713FSTfs Air LLC · Loveland, CON713GFFleming Geoffrey R Jr · Port Saint Lucie, FLN713JHMccauley James · Ithaca, NYN713JKSbarounis Carl A · Torrance, CAN713KRegistered aircraftN713LULiberty University School Of Aeronautics · Lynchburg, VAN713MATraining Wheels & Advanced Technologies LLC · La Salle, CON713PMWestbank Fishing LLC · New Orleans, LAN713RBKay Timothy A · Kyle, TXN713SATextron Aviation Inc · Wichita, KSN713SJKoerner James L Trustee · Gilbert, AZN713SMJa Williams Investments LLC · Austin, TXN713SZN713sz LLC · Jacksonville, FLN713TGSelway Construction Group LLC · Moscow, IDN714United States Department Of Interior · Boise, IDN71400Wubben Robert C · Waupaca, WIN71405Bowes John Michael · Lake City, FLN71408Emerald Darin · Springerville, AZN71409Piedmont Flight Inc · Winston Salem, NCN7140EJ W Bamford Inc · Oroville, CAN7140FLogan Gregory A · Chouteau, OKN7140JCohesive Aviation LLC · Gilford, NH
Back to AD 79-10-14 R1