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.
N8741SJohnson Zachary R · Burien, WAN8741TTolman Jeremy Charles · Mcalester, OKN8741USexton Mathew G · Rockwell City, IAN8742BTexas Wings LLC · San Antonio, TXN8742GReeve Howard E · Minot, NDN8742UJennings Jeff L · Kenly, NCN8742XGarletts Frank A · Jackson, MSN8744SZiegler Jeffery A · Crescent Springs, KYN8744TEdhlund Joseph W · Brush Prairie, WAN8745GWildcat Aviation LLC · Schoolcraft, MIN8745XScott William R · Monroe, GAN8746BHeffron Jacob L · Little Falls, MNN8746XBlack Kevin R · Massillon, OHN8747SEast County Communications Inc · Hurricane, UTN8747URegistration Pending · Indio, CARegistration pendingN8747XJodoin Michael G · Belton, SCN8747ZMermaid Marine LLC · Auburn, WAN8748BOstby Larry · Froid, MTN8748SJones Joel K · Summer Shade, KYN8748TDennis Richard E · Gakona, AKN8749SHart Richard G · Stoneham, MAN8749UHendrickson Flying Service Inc · Rochelle, ILN8749ZRegistered aircraftN874DTN874dt LLC · Canadensis, PAN874EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN874JSchoenmann James · Jackman, MEN8750BLawson Winston P · Hillsboro, OHN8750GMoe Charles E · Rosebud, SDN8750SStarcher Paul E · Las Vegas, NVN8750UHenryetta Airman Inc · Morris, OKN8750ZArge Aviation LLC · Montana City, MTN8751GCrotts Joseph D · Mocksville, NCN8751SMorris Jeffery S · Ukiah, CAN8752TTortorige Carl J · Quincy, ILN8752UFarm Air Corp · Hoxie, ARN8752XSmith Timothy R · Auburn, CAN87534Registered aircraftN8753TZaccheo Vincent S · Ulster Park, NYN8753USowash Allan D · Ontario, OHN8753ZBloated Armadillo Adventures Corp · Wilmington, DEN8754BFoster Steven M · Pekin, ILN8754QD2 Holdings LLC · Salt Lake City, UTN8754TBurrington Steven A · Austin, TXN8754XSutton Aircraft Salvage LLC · Palmer, AKN8754ZBwana Z Transporation LLC · Missoula, MTN8755BBurton Mark L · Lebanon, OHFirst renewal noticeN8755QMartensen Marten · Anchorage, AKN8755UDouglas-Carter Tammi A · Greenville, KYN8756QTriple 2 LLC · Burlington, CON8756XGabelli Casey · Ridge Manor, FL
Back to AD 79-10-14 R1