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.
N5088APieper Mike D · Chandler, OKN5088DBaughman Jeffrey S · Keller, TXN5088ES J Screw Company Inc T/A · Belvidere, NJN5088KG & M Aircraft Inc · Wheat Ridge, CON5088QMetro Aircraft Co · Bloomington, MNN5088RGlacier Equipment LLC · Wasilla, AKN5088USinnott Simonis Lyle · Girdwood, AKN5089Gifford David M · Las Vegas, NVN50891Peterson Andrew B · Louisville, KYN50896Bankhead David B · Montrose, WVN50898Costa Air Service LLC · Painted Post, NYN5089ABagley James R · Twentynine Palms, CAN5089C5089c LLC · Fairhope, ALN5089DMorales Josh S · Anchorage, AKN5089EEgger Gary L · Edmond, OKN5089GFlywell Aviation LLC · Bowling Green, KYN5089JWentzel Ron · Steamboat Springs, CON5089RHigh Wing Air Services LLC · Merritt Island, FLN5089V89v LLC · Bethlehem, PAN508EJones Ronald C · Walters, OKN508FGRidgeline Assets LLC · Wilmington, DEN508NDCorsair Aviation LLC · Pacoima, CAN508SDPate Charles C Trustee · Wichita, KSN508TCFisher Travis L · Odessa, TXN508WLCampbell Robert · Kingman, AZN50901United Indian Missions Inc DBA · Tucson, AZN50904Karges Kip · Tuscola, TXN50906Aitken & Wilson Aviation LLC · Leesburg, VAN50909Keystone Aviation Group LLC · Paxinos, PAN5090EMelbourne Flight Training LLC · Melbourne, FLN5090RStahla Russell A · Girdwood, AKN5090UVolatile Aero Ventures LLC · Boulder City, NVN50911Graves Robert E · Danville, INN50914Calhoun John R · Baton Rouge, LAN50915Donato Robert J · East Berlin, PAN5091717 Leasing LLC · Englewood, CON5091DKuhn Chad · Boulder, WYN5091EAmerican Asset Leasing LLC · Aurora, ORN5091VWilliams Timothy J · Fernandina Beach, FLN50920Campbell James R · Temple City, CAN50921Hernandez Jesus C · Elberton, GAN5092AHansen Aviation LLC · Savannah, GAN5092EKaye Russell G · New Fairfield, CTN50935Civil Air Patrol Inc · Maxwell Afb, ALN50936Qualitair LLC Trustee · MichelstadtN50937Tls Aviation LLC · Eldridge, IAN50939Heart X Aviation LLC · Salmon, IDN5093EBohmer Carla M · Tulsa, OKN5093KL A M Capital Management LLC · Sheridan, WYN5093RSkyhawks Inc · Montoursville, PA
Back to AD 79-10-14 R1