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.
N8182ERed Arrow Aviation LLC · Santa Teresa, NMN8182UMorristown Flying Service Inc · Talbott, TNN8182ZWolf Richard Cory · Syracuse, UTN8183ARegistered aircraftN8183FArvizu Jason Arthur Scott · Bakersfield, CAN8183MHaman Peter A · Douglas, WYN8183THysell Donovan · Atwater, OHN8183UMacauley Richard D · Shingle Springs, CAN8184BPalouse Aviation Holdings LLC · Moscow, IDN8184GAspire Aviation LLC · Farmingdale, NYN8184LVanderlaan Dirk C · Reno, NVN8184TGraham Steven K · Mc Grath, AKN8185GJohnston John Lane · Houston, TXN8185SJanssen Christopher M · Manchester, IAN8185VCryan Mark · Port Orange, FLN8185ZViele Mark C · Buckley, WAN8186BMid-Atlantic Aircraft Leasing LLC · Wilmington, DEN8186LBolsover Douglas J Sr · Cameron Park, CAN8186TBouton Vern H · Fairbanks, AKN8186ULake Area Technical College · Watertown, SDN8186ZBernard David John · Damascus, MDN8187BWithers Hurchel W · Stone Mountain, GAN8187FCoady Michael J · Taylorville, ILN8187MMoose Eddy · Tyler, TXN8187SCounter Kevin · Windsor, CAN8187TLawdawg Property Rentals LLC · Williston, NDN8187VNelson Brett R · Shoreview, MNN8188ZHzl Hanger LLC · Drums, PAN8189AEight Niner Alpha LLC · Eagle, IDN8189FArchuleta Michelle L · Las Cruces, NMN8189GBeebe Brad A · Clinton, MON8189XQuire Gregory L Sr · Shepherdsville, KYN8189ZMirage Mfg Co Inc · Gainesville, FLN818ARLandsworth Corp · Monterey, CAN818CPCivil Air Patrol · Maxwell Afb, ALN818EPEpic Aviation Inc · New Smyrna Beach, FLN818EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN818HFlorez Oscar · Independence, KSN818MLTurning Point Northwest LLC · Stanwood, WAN818SPN818xp LLC · Charleston, SCN8190LOlsen Curtis O · Lindon, UTN8191FMoore Clayton P · Cayce, SCN8191GGroce James D · Portland, ORN8191SStang Daniel Jr · Lindale, TXN8191TDavis Jonathan L · Pleasanton, CAFirst renewal noticeN8191UAnderson Amy J · Manistique, MIN8192BAll Sports Aviation LLC · Sandpoint, IDN8192ESalerno Michael P · Pueblo, CON8192LSteinmetz William · Lakeville, INN8192TFranke Darren W · Yorktown, TX
Back to AD 79-10-14 R1