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.
N759HPWinchester Skylane Flyers LLC · Winchester, VAN759HQDellinger Hughes R Jr · Gloucester, VAN759HRMountain Vista Aviation LLC · Los Alamos, NMN759HSUlrich Michael J · Lancaster, PAN759HTKflg LLC · Flagstaff, AZN759HXLabell Aviation LLC · Spring Hill, FLN759HYIrwin Dennis R · Darby, MTN759HZCade Michael · Sonoita, AZN759JASturgeon James L · Spring Hill, FLN759JBMpms Inc · Munford, TNN759JDEnne · Memphis, TNN759JFCrc Aviation LLC · Woodville, MSN759JGMgvw Capital Holdings LLC · Saint Petersburg, FLN759JH3d Capture LLC · Lumberton, TXN759JMAas LLC · Ovid, MIN759JNMike Rinker Aircraft LLC · Union City, TNN759JRSeks Ventures Inc · Middletown, DEN759JXOptic Air LLC · Maurice, IAN759KAAtmore Places LLC · Fernandina Beach, FLN759KBBoschma Henry F · Terrebonne, ORN759KCMccrea Daniel B · Waldport, ORN759KDRegistered aircraftN759KGWhite Thomas G II · Knoxville, PAN759KJJohnson Thomas N · Greensboro, GAN759KKWesterlin Harrington Flying Service Inc · Holdrege, NEN759KMDahlen Donald · Isle, MNN759KPSc-Dsc LLC · Rocklin, CAN759KQKudrna Kenneth D · Poplar Grove, ILN759KSAlessio Pretto G · Pawling, NYN759KTFrancis Larry Lee Dds Pc · Evanston, WYN759KVGorman Peter J · Valley Center, CAN759KWRodgers Robert W · Louisville, KYN759LCPegasus Aviation LLC · Moscow, IDN759LDKnutson Wayne R · Thompson, NDN759LEFridell Terrell · Charlotte, NCN759LFMurphy Carl Lee · Gastonia, NCN759LGTilton Glenn E · Cheyenne, WYN759LHKent William C Jr · Memphis, TNN759LKCs III Aviation LLC · New Orleans, LAN759LPAzar Suzanne S · El Paso, TXN759LUMike-Upd LLC · Roseburg, ORN759LVJav Air Services LLC · Anchorage, AKN759LWOlson Dave · Richardton, NDN759LXLexiair LLC · Little Mountain, SCN759MAValley Fliers Inc · Auburn, WAN759MBMiller Curtis Vern · Sugar Land, TXN759MKFarnsworth Harold · Mesa, AZN759MQPretre Alan G · Mitchell, SDN759MSMechanical Construction Services Inc · Newark, ARN759MUCool Creek Aviation LLC · New Orleans, LA
Back to AD 79-10-14 R1