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.
N4856DOlsen Ernest D · Lino Lakes, MNN4856GNatchez Flight Training LLC · Natchez, MSN4856VColombie Michael A · Anchorage, AKN4857CGate Holdings LLC · Ketchum, IDN4857DMarkwood Bruce A · Anchorage, AKN4857GVero Technical Support Inc · Pensacola, FLN4857UColorado Aviators LLC · Gypsum, CON4857VNewsouth Aviation LLC · Auburn, ALN4858DRostron Kenneth E · Eagle Nest, NMN4858UD & D Adventures LLC · Cleveland, TXN4859CHanni Walter G · Anchorage, AKN4859FRidgway Stephen · Avon, CON4859GAirgo Inc · Centralia, ILN485CACivil Air Patrol · Maxwell Afb, ALN485FBrook Trout Air LLC · Cle Elum, WAN485GRegistered aircraftN485JMSanders Flight Training Center Inc · Jasper, ALN485SBLyddon Aero Center Inc · Liberal, KSN485VL & W Leasing LLC · Smyrna, TNN4860DWeinheimer Jeffrey T · Onida, SDN4861DThornquist Robert K · Anchorage, AKN4861GFlying Colors Airparts Inc · Leesburg, FLN4861UGoodmanagement Healthcare Inc · Chandler, AZN4861VRegistered aircraftN4862DHixson G C · Readyville, TNN4862EGyuro Stephen Douglas Trustee · Benton, KSN4862UDodson International Parts Inc · Rantoul, KSN4863QKlamar Spraying Inc · Gatzke, MNN4863USpot Aviation LLC · Nevada, IAN4864DChiota Aviation LLC · Waco, TXFirst renewal noticeN4864GLazy Eights Holdings LLC · Greenwood, INN4864YWilliams R E · Fort Walton Beach, FLN4865DBlack Hound Aviation LLC · Austin, TXN4865UMajor Richard L Jr DBA · Hickman, KYN4866DBetts Thomas L · Fort Collins, CON4867CWeishaar Traig Tl · Odessa, WAN4867DFlynn Brian · Auburndale, FLN4867UFeyen Richard F · Kaukauna, WIN4868EVero Technical Support Inc · Pensacola, FLN4868NWisner David · East Hampton, NYN4869CBerry Matthew G · Creedmoor, NCN4869DCutler Donald R · Bolivar, MON4869NBlack Hawk Brothers LLC · Lakeland, FLN486CACivil Air Patrol · Maxwell Afb, ALN486CPCivil Air Patrol · Montgomery, ALN486ERUw Flying Club Inc · Sun Prairie, WIN486MSInternational Air Services Inc Trustee · Carson City, NVN486TCMonte D Burke · Dallas, TXN4870CHoffman Bertha M · Bethel, AKN4870DSherman Hess M · Poplar Grove, IL
Back to AD 79-10-14 R1