AD 79-11-05 R1
Registered aircraft · 98
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-11-05-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-11-05-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-11-05-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-11-05-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.
N100JMGregg Delvin K · Durango, CON101CRush David T · Durham, NCN118CWilke Brian S · Arlington Heights, ILN119CAn Yongmin · Phoenix, AZN120CVasquez Bernie W · Esparto, CAN123CKing Stephen W · Kerrville, TXN125CMaitland David L · Culpeper, VAN18CTAugustin Lyn H · Saint Thomas, NDN18GSSlad George W · Albuquerque, NMN201MMHarms Karen · Napa, CAN223VSheppard Alan J · Onamia, MNN246MMHildreth Shawn M · Osceola, IAN283DEMccrath Michael E · Seattle, WAN3162KDouthit Norman L · San Bernardino, CAN3165KHackenburg Jess P · Montoursville, PAN325MMandibles Edward Jr · Lompoc, CAN335MCabbage David A · Colville, WAN339MGagne Gilbert R · Apple Valley, CAN342MEtling Kurt Karl · Edgewood, TXN344MAxford Dwayne E · Wheatland, WYN346MLester Stephen P · New Smyrna Beach, FLN353ALee Jonathan C E · Bossier City, LAN361ADouthit Norman L · San Bernardino, CAN363ADoutnit Norman L · San Bernardino, CAN366ARamin Reuben F · Tomball, TXN369AStrange Jim · Tyler, TXN371ABeltz Richard D · Lehighton, PAN378ASpicer Michael W · Phillipsburg, KSN379AWingnut Inc · Wilmington, DEN382ADga Aviation LLC · Sacramento, CAN383AKlenoski Brian D · Fulton, MIN384APlyler Aviation Lp · Sherman, TXN386AOrtet Craig · Etna, WYN391ATwibell David Jerome · Ceresco, NEN393ACollins Elizabeth M · Carnelian Bay, CAN4055Olegueoa Jesse V · Riverside, CAN4057Dix Walter R Jr · Winter Haven, FLN4065Hughes Roger L · Corpus Christi, TXN4068Lovley Forrest T · Jordan, MNN4070Dodson David W · Granger, INN4073Fritz David C · Lincoln, NEN4075VNiva Gary W · Monte Sereno, CAN4076Morgan Jeff P · Justin, TXN4078Loffert George U Jr · Killeen, TXN4088Katz Matthew · Los Angeles, CAN4094Kopec Craig W · Long Beach, CAN4095Jenkins James L · Lake Stevens, WAN4096Lewis Scott C · Los Angeles, CAN4097Puhlmann Otto B · Logan, UTN4101Connolly Luke A · Blaine, MN
Back to AD 79-11-05 R1