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.
N5139UCoosa Valley Aviation Inc · Wilmington, DEN513CTCoast Flight Training And Management Inc · San Diego, CAN513EREmbry-Riddle Aeronautical University Inc · Prescott, AZN513LFLunken Flight Training Center LLC · Cincinnati, OHN513MCWilliams Val · Victor, IDN513NDAerosim Academy Inc · Sanford, FLN513SWilliford James Q · Wilson, NCN513SCInstant Whip Foods Inc · Columbus, OHN513SPPlane Old Inc · New York, NYN513TDWeber Sandra L · Simpsonville, SCN513WFMeow Meow LLC · Seattle, WAN51400Clark Paul W · Alexandria, MNN51401Dowling Connor · Edmonds, WAN51403Remigy Mathias E · Peterborough, NHN51406Mh Aviation LLC · Le Mars, IAN5140ALizarralde Lorenzo · Jackson, MIN5140ESadosky Paul · Glendale, WIN5140QMccoy David J · Perryton, TXN5140RAshby Artie Dale Jr · Madison, ALN51410Good Paul H · Long Island, VAN51411Lambourne Robert · Pensacola, FLN51412Record John W · Apison, TNN51413Mcpike William C · Ludington, MIN51415Van Voorhis Adam P · Groton, CTN51416Murphy Nicholas Raymond · Kenai, AKN5141ESkywagon 41 Echo LLC · Pine, CON5141JSasser Nancy Elizabeth · Petaluma, CAN5141KGilbertsville Flying Service LLC · Gilbertsville, PAN5141QImagination Publications Inc DBA · Saratoga, WYN5141RServant Air Ministries Inc · Merritt Island, FLN5141YCommonwealth Of Virginia · Fort Monroe, VAN5142EBedford Dennis L · Auke Bay, AKN5143DMacbeth Keith Adam · Thompson, UTN5143JSkywarrior Flight Training Inc · Pensacola, FLN51448Haley Robert · Livermore, CAN5144NL-3 Communications Eo/Ir Inc · Loveland, CON5144RBuffalo Flying Club Inc · Ayr, NDN5144UAeronaut LLC · Saint George, UTN5145AMccullough Ronnie W · Golden, CON5145ESierra Pacific Aviation · Willits, CAN5145KZulu Jets LLC · Boerne, TXN5145RSautner Steve · Anchorage, AKN5146DAnderson Daniel S · Payson, AZN5146QJ&G Aero Investments Group LLC · Wilmington, DEN5146VFischer John W · Waukesha, WIN51470Merryman Stephen R · Beach City, TXN51472Breaks Bound LLC · Kalispell, MTN5147EDirty Side Down LLC · Noblesville, INN5147HBeyond Willpower Inc · Shreveport, LAN5147JN5147j LLC A Series Of Aero Lease LLC · San Antonio, TX
Back to AD 79-10-14 R1