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.
N5464KTrend Vector Aviation International Inc · Barrigada, GUN5464QBinsfeld Thomas · Chico, CAN5464TJackson Tyler H · Kittery, MEN5464VLivingood Richard A · Tucson, AZN5465BFischer Alfred M DBA · Genoa City, WIN5465COliphant Donald E · Benbrook, TXN5465KMonroe Pilots Association LLC · Monroe, NCN5465QWhitford John T · South Weber, UTN5465RHaffley And Ruiz LLC · Waco, TXN54661Executive Flyers Inc · Sacramento, CAN54663Colorado Northwestern Community College · Rangely, CON5466CLewis Elijah J · Luthersville, GAN5466D5466 Delta LLC · Costa Mesa, CAFirst renewal noticeN5466EPeterson Paul E · Port Charlotte, FLN5466QDe Sciscio Salvatore A · Chaplin, CTN5466THildebrant Virginia Fay · Fall City, WAN54678Aero Association Of Caltech Inc · Pasadena, CAN5467APiedmont Air Services LLC · Helena, MTN5467BSwank Michael G · Shreve, OHN5467CSteamboat Springs Flying Club Inc · Steamboat Springs, CON5467RCarter Roy T · Shepherdsville, KYN5467TRegistered aircraftN54680Yanagida Kazuaki · Norco, CAN5468BCullinane Patrick J · Pasco, WAN5468ELehr Robert J · Pleasant Dale, NEN5468HPrjc Properties LLC · Vonore, TNN5468RCw Arborists Ltd · Killingworth, CTN5469BDo Enterprises LLC · Port Charlotte, FLN5469KAviation Specialists Inc · Apison, TNN546ASouthern Illinois University · Murphysboro, ILN546EREmbry Riddle Aeronautical University Inc · Prescott, AZN546KWard Mark E · Brookfield, WIN546MCLeaseair LLC · Wilmington, DEN546NDSpartan Education LLC · Tulsa, OKN5470KSkye Aircraft LLC · Deland, FLN5470QBuiqui Aerospace Corp · Kissimmee, FLNon-citizen corporation, flight hours not reportedN5470TLesnick Robert E · Charlotte, NCN54715Apt Aero LLC · Port Angeles, WAN5471BLowenstein Jeffrey · Juneau, AKN5471NRiley Aviation LLC · Columbia, TNN5471QGunnarsson Jon · Concrete, WAN5471RGq Aviation LLC · Cherry Hill, NJN5471TWiesen Michael J · Waldo, FLN54728Vig Cheryl J · Opal, SDN5472KHayes Aviation LLC · New Smyrna Beach, FLN5472QAmf Diversified LLC · Mesa, AZN5472RAnderson Craig D · Mission Viejo, CAN54733Gofastpilots LLC · Roswell, NMN54734Southern Arkansas University Tech · Camden, ARN54739Skylens LLC · Hammond, LA
Back to AD 79-10-14 R1