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.
N9957XHutchison Robert T · Big Lake, AKN99583Motz Gary A · Bemidji, MNN99589Kingsky Flight Academy LLC · Lakeland, FLN9958AChase Kevin J · Anchorage, AKFirst renewal noticeN9958BSouthern Aircraft Leasing LLC · Montgomery, ALN9958EAirtauk LLC · Montauk, NYN9958HCity Of Albuquerque · Albuquerque, NMN9958NShimpa Michael A · Maple Grove, MNN9958TKonefal Arthur J · Fairbanks, AKN99598Registration Pending · Argyle, TXRegistration pendingN9959ANelson Jayson A Trustee · Caldwell, IDN9959BHackamore Equipment LLC · Prairie City, SDN9959ETyler Matthew S · Lakeside, CAN9959HThibault William N · Newport Beach, CAN9959RRusyniak Anthony J · Syracuse, NYN9959XMiller Keith D · Pittsburgh, PAN9959YGrand Aviation LLC · Winter Park, COFirst renewal noticeN995CPCivil Air Patrol Inc · Maxwell Afb, ALN995JAN995ja LLC · Ft Lauderdale, FLN995NABucher Devin V · Kalispell, MTN995SBRossi Randall A · Georgetown, TXN995VZMeyerowitz Noah A · Great Barrington, MAN995WWMoore Aviation Inc · Beaver Falls, PAN99606Civil Air Patrol Inc · Maxwell Afb, ALN9960BSouthern Aircraft Leasing LLC · Montgomery, ALN9960EArklamiss Aviation LLC · Ruston, LAN9960NBoemer Steven E · El Cajon, CAN9960RInternational Air Services Inc Trustee · Carson City, NVN9961ERuryk Jonathan D · Pineville, LAN9961VCk Leasing Services LLC · Wilmington, DEN9962ESynergy Financial Services Inc · Vancouver, WAN9962MFox Aircraft LLC · Bethel, AKN9962TWh72 LLC · Lincoln, NEN9963EDenski David T · Plymouth, MIN9963NWoodward Aviation LLC · Alpine, TXN9963YN9963y LLC · Provo, UTN9964CTakle Management LLC · Bethany, OKN9964EJansen Christopher · Stilwell, KSN9964HBuchanan Gary · Jay, FLFirst renewal noticeN9964KState Of Wisconsin Department Of Administration · Madison, WIN9964LHess Garrett J · Fullerton, CAN9964YGreenspun Mark H · Washington, DCN9965ARobertson Francis E · Hibbing, MNN9965BTuma Tom · Cut Bank, MTN9965PAmeriflyers Of Texas Inc · Addison, TXN9965XNistler Matt J · Three Forks, MTN9966BKimbrell Heath · Quinlan, TXN9966NBeeson John Charles · Palmer, AKN9966TItalio River Adventures LLC · Yakutat, AKN9966VLeisner David L · Palmer, AK
Back to AD 79-10-14 R1