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.
N9346DHolloway James H · Merritt Island, FLN9347GNazir Donna Lacruz · Boca Raton, FLN9347HWings Like Eagles LLC · Wilmington, DEN9347TLewis University · Romeoville, ILN9347UAirgo Inc · Centralia, ILN9348FDirty Side Down Aviation LLC · Georgetown, TXN9348HDeshazer Bill G · Gladewater, TXN9348XWhittemore Kenneth P Jr · Fredericksburg, VAN9349MDouble R Air LLC · Miami, FLN9349XDicarlo Jason M · Covington, LAN934AZN934az LLC · Miami, FLN934CPCivil Air Patrol · Maxwell Afb, ALN934EREmbry Riddle Aeronautical University · Daytona Beach, FLN934GRGrossman Robert W · Andover, MAN934MT8th Dimension Enterprises LLC · Englewood, CON934TCVandentoorn Randy J · Caledonia, MIFirst renewal noticeN934TRAris Leasing Inc · Sunnyvale, CAN9350BHoman Ralph C · Weiser, IDN9350CCloud Dancer Inc · Berlin, MDN9351DJennings David M · Huffman, TXN9351FCarr Sam H · Spring, TXN9351HBrown Daniel Thomas · Layton, UTN9351UHolt James D · Greensboro, NCN9351XSasser Konnie B · Granbury, TXN9352CSage Blue LLC · Yakima, WAN9352XLinhart Charles W · Dayton, WYN9353DRegistration Pending · Simi Valley, CARegistration pending, canceledN9353ECivil Air Patrol Inc · Maxwell Afb, ALN9353GMisyukevich Konstantyn · Clarkston, MIN9353YKovax Aviation LLC · Youngstown, OHN9354BC2 Aero LLC · Dallas, TXN9354CSmith Richard M · Stanwood, WAN9355CGrobbelaar Warren · Naples, FLN9355NGardner Tyler J · Lowell, MEN9355RSkyline Aviation LLC · Lewistown, MTN9355XTaylor John A · Lexington, MAN9356BWard Clayton D · Mcville, NDN9356HQuad Cities Aero LLC · Bettendorf, IAN9356XGibson Kenneth W · Washougal, WAN9356YParsons Bruce W Trustee · Costa Mesa, CAN9357GPpp Investments LLC · Lexington, MSN9357TBonafide Investments LLC · Dover, DEN9357UBaldwin James S · Sylvania, OHN9358ELechmanski Philip J · Shelter Island, NYN9358GBig Sky Plane Holdings LLC · Kalispell, MTN9358LUnited States Air Force · Eglin Afb, FLN9358NHarvey Kandace A · Snohomish, WAN9358USaddedine Nouredine · Frisco, TXN9359BPalinsky Gary C · Au Gres, MIN9359CAero Sport Craft LLC · Havre De Grace, MD
Back to AD 79-10-14 R1