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.
N6699AAdderley Allan M · Hernando, FLN6699EWheeldon Chancy R · Jackson Hole, WYN6699GBailey Matthew T · Cornelius, ORN6699TFlory Michael Scott · Eldorado, TXN669CBMckinney Eric · Hamersville, OHN669EBBauman Ed · Casstown, OHN669EREmbry-Riddle Aeronautical University Inc · Prescott, AZN669FGMustang Sally Aviation LLC · Camden, SCN669GAWilson Victor A · New Albany, OHN669JKGeddes Michael · Seattle, WAN669PDBarder David A · Millersburg, PAN669PGGood Pilot LLC · Dallas, TXN669SRCabot Scott R · Cross Plains, WIN669TWAlmanor Express LLC · Palo Alto, CAN66AALift Aviation LLC · Kingston, MAN66BDCampanella Stephen · Brunswick, OHN66BLLemon Bryant William Jr · Albuquerque, NMN66BTTrazer LLC · Parkland, FLN66CEM&S Real Estate Management Inc · Granbury, TXN66DFClark Samuel D Trustee · Wilson, WYN66DTTucker Family Agricultural Co LLC · Kiowa, KSN66GAAircraft Guaranty Corp Trustee · Oklahoma City, OKN66GVPearson Robert L IV · Spartanburg, SCN66HERausch William Donald · Ontario, NYN66KJBlagg Robert D III · Santa Fe, NMN66LLLetourneau Duane R · Oconto, WIN66LYRapid Fleet II LLC · Carmel, INN66MACp Aviation · Santa Paula, CAN66MEDm Asset Management LLC · Plain City, OHN66MJUnited States Air Force (Owner) · Usaf Academy, CON66MLBas Part Sales LLC · Greeley, CON66MMTake Flyt LLC · Eagle Lake, MNN66PArchangel One LLC · Lewes, DEN66PRPeterjohn Management II LLC · Pound Ridge, NYN66RHBoniek Johann C · Nederland, CON66RXRegistered aircraftN6700HNashua Flyers Inc · Nashua, NHN6700SAgape Enterprises · Montana City, MTN6700TKimmerle David · Blanding, UTN6700XAlbert Gregory T · Tucson, AZN6701AClarke Christopher E · Cincinnati, OHN6701FHale James W · Darrington, WAN6701SKnipping Richard W Jr · Winterport, MEFirst renewal noticeN67022Mccormack James · Mount Jewett, PAN6702AWitte Troy A · West Plains, MON6702ERegistration Pending · Danbury, CTRegistration pendingN6702FVirnig Joshua B · Deerwood, MNN6702HGoetz Terry L · Defiance, IAN6703AMankovich Douglas P · Punxsutawney, PAN6703FBargabos Julie A · Canastota, NY
Back to AD 79-10-14 R1