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.
N5639RKeith L S · Forestburg, TXN563EREmbry-Riddle Aeronautical Univerity Inc · Prescott, AZN563FAWang Yuemin · Wauconda, ILN563FSPatterson Marshall S · Tuscumbia, ALN563GMarsh Matthew · Cleveland, ALN563GSGilderhus Edwin T · Oberon, NDN563NDAerosim Academy Inc · Sanford, FLN563RSRaven Bryan F · Lakeland, FLN563SPSloan Joseph · Lancaster, CAN5640ASanders David L · Powell, WYN5640BN5640b LLC · Ashburn, VAN5640EHunt Jacky R · Bowling Green, KYN5640RUnruh Jerel W · Versailles, MON5641BGoebel William R · Rhome, TXN5641REaton Samuel D · Clinton, PAN5641TMarcy Dara Owen · Tacoma, WAN5642AMoore Alton O III · Lago Vista, TXN5642JGreater Houston Soaring Association · Needville, TXN5642RMatheny Roger P · Humble, TXN5643ARosansky Jeff S · Weldon Spring, MON5644BSchmidt Ross A · D-63329 EgelsbachNon-citizen corporation, flight hours not reportedN5644CRegistered aircraftN5644RShaffer Mark J · Porterfield, WIN5644TScootair LLC · Alburgh, VTN5645AAll Seasons Catering Inc · Shelter Isl, NYN5645BHenderson William R · Ohatchee, ALN5645EHagen Edward E · New Auburn, WIN5645RGecha Brian S · Brandon, VTN5645TJ & J Aviation Inc · Martinsville, VAN5646AHeffron Jacob L · Little Falls, MNN5646BSkydive Ky LLC · Cecilia, KYN5646CBivens Jason D · Duncan, OKN5646RAumack Bryant D · Melbourne, FLN5647GDarter Lloyd R · Mountain Grove, MON5647TJohnson Jeffri K · Brighton, CON5648AMartin Rand E · Lake Stevens, WAN5648BBailey Carl · Huntington, WVN5648EHanna Charles M · Luthersville, GAN5648JSswb Enterprises LLC · Lufkin, TXN5648RKurtz Richard G · Ithaca, NYN5648TYankton Area Aviators Inc · Crofton, NEN5649AMinor Charles G · Medford, ORN5649CRon Alexander Youth Aviation Program · Williamson, GAN5649GMaran Properties LLC · Lowell, ARN564ATMustang Sally Aviation LLC · Camden, SCN564CMurray Robert G · Eudora, KSN564DSLopez John · Prole, IAN564EDTilse William A · Kirkland, WAN564GHughes Ramzi S · Alamo, NVN564LMSky Horse LLC · Santa Cruz, CA
Back to AD 79-10-14 R1