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.
N962AUAuburn University · Auburn, ALN962CPCivil Air Patrol · Maxwell Afb, ALN962JBNational Aircraft Leasing Corp · Greenville, DEN962LTUniversity Of La System DBA · Ruston, LAN962PBNational Aircraft Leasing Corp · Greenville, DEN962RGBoucher John C · Lakeside, AZN962SHObermeier Scott D · Manchester, CTN9630QKelley Aircraft LLC · Weyers Cave, VAN9630TBridgford Bruce H · Anaheim, CAN9630VN275508 LLC · Margate, FLN9630XSea-S-Ta Aviation LLC · Alexandria, VAN9631BPercy Flyers LLC · Dexter, MIN9631QHuntsman Ferral Don · Juneau, AKN9631VHarrold Bruce E · Greybull, WYN9632AHiter Henry P Jr · Merigold, MSN9632BDbstd LLC · Nickerson, NEN9632HSweitz-Air Inc · Stewartstown, PAN9632ZAngelone Inc · Elkhart, INN9633ASmith Herschell C III · Panama City, FLN9633HWings Over Texas Holdings LLC · Denton, TXN9633XCivil Air Patrol Inc · Maxwell Afb, ALN9634QDubois County Flight Services Inc · Huntingburg, INN9634XScoggin Gerald William III · Port Saint Lucie, FLN9635BFisher Frank L · San Diego, CAN9635HArizona Aircraft Leasing LLC · Mesa, AZN9635LAcme Club Training Inc · Anchorage, AKN9635QRozynski Jason K · Malabar, FLN9635V35 Victor LLC · Decatur, GAN9636HMontanez Orlando · Guaynabo, PRN9636VNaperville Flying Club · Woodridge, ILN9636YCarranza Chris J · Stanfield, AZN9637AMutz Paul J · Rocklin, CAN9637QWingsleasing LLC · Wichita, KSN9637VAllen Linda M · Amarillo, TXN9637XCypress Peak LLC · Pickens, MSN9638HHatbright Farm LLC · Wilmington, DEN9638QPeterson John E · Benton, KSN9638VCrazy Aces LLC · St George, UTN9638XPiper Earl Holdings LLC · Newark, DEN96393Graham Eric H · Johnson City, TXN9639APhyfe Andrew L · Cape Coral, FLN9639XFerguson John · Montrose, CON963ACYoung Paul J · Hudson, MAN963AUAuburn University · Auburn University, ALN963CPCivil Air Patrol · Maxwell Afb, ALN963EREmbry-Riddle Aeronautical University · Daytona Beach, FLN963JADeland Aviation LLC · Deland, FLN963KMMiller Karl E Trustee · Chandler, AZN963LTUniversity Of La System DBA · Ruston, LAN963SPAero Aircraft 11 LLC · Jacksonville, FL
Back to AD 79-10-14 R1