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.
N6590MOpm Holdings LLC · Wilmington, DEFirst renewal noticeN6590SCoonley Russell F · Decatur, TXN6591EWay Robert Louis · Morristown, AZN6591NRickey James R · Hanford, CAFirst renewal noticeN65923Noste Erik · Mount Vernon, WAN6592EPreszler Terence H · Braddock, NDN6592SBasista Robert J · Delaware, OHN6592TLill Steve P · Lafayette, LAFirst renewal noticeN65937Berendschot Leonardus · Huntsville, TXN6593SMilam David N · Hannibal, MON6593XWondra J Paul · Newbury Park, CAN6594EAirlake Aero Inc · Lakeville, MNN6594GKabat Orville · Rudyard, MIN6594MRayburn William E · Oak Harbor, OHN65956Ameriflyers Of Texas Inc · Addison, TXN65957Skybourne LLC · Stuart, VAN6595FRose Edward · Brooklyn, NYN6595G95 Golf Inc · Greenwood, INN6595SGlobal Flight Training Solutions Inc · Immokalee, FLN6596DMcdonald Kevin K · Anchorage, AKN6596ELaughrey Jeffrey L · Soddy Daisy, TNN6596FTrenholm Daniel L · Eagan, MNN6596MEjs Enterprises Inc · Three Forks, MTN6596TSuss Charles · Woodford, VTN65978Freeland Christopher G · Brownwood, TXN6597EPrintz Thomas L · Springfield, OHN6597GOff Airport Adventures LLC · Saint David, AZN65981Registration Pending · Dubuque, IARegistration pendingN65984Woelbing Aviation LLC · Franksville, WIN65985Moreira Hiosvany · Pensacola, FLN65986Ahern Michael · El Reno, OKN65988Arkansas Industrial Manufacturing LLC · Wilmington, DEN6598ESmith Jeff · Papillion, NEN6598TSwanson Duane R · Simi Valley, CAN6598XVolk Kenneth L · Waskom, TXN65991Crysler Douglas Michael · Rockford, MIN65992Holseberg Aviation LLC · Ridgeville, SCN65994Christiansen Aviation LLC · Wilmington, DEN65995Phoenix Flyers Inc · Mesa, AZN65997Dalton John C · Hernando, MSN65999Vaughn Thomas N · Shallowater, TXN6599DBlue Shield Aviation LLC · Saint Petersburg, FLN6599FSiebe James E · Moscow, IDN6599MSieben Livestock Co · Helena, MTN659BPArnold Airplane LLC · North Branch, MNN659EREmbry-Riddle Aeronautical University Inc · Prescott, AZN659SDCall David A · Carson City, NVN659SPChristiansen Aviation LLC · Wilmington, DEN65AMDorroh Frederick A · Ardmore, OKN65BBHoogasian Stephen M · Manassas, VA
Back to AD 79-10-14 R1