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.
N78523Sunderman Randy · Norfolk, NEN78525Aero II Inc · Spartanburg, SCN78526Miklus Michael III · Saint Georges, DEN7852UMartinson James C · Sioux Falls, SDN7852ZKvservices LLC · Buckley, WAN78531Goodridge Flying Club Inc · Goodridge, MNN78538Drover Michael A · Winter, WIN7853ARegistered aircraftN7853EFelton Marion L · Dickens, IARevoked, canceledN7853FEdwards Michael J · Hazlehurst, GAN7853TBailey Ned A · Friday Harbor, WAN78542Tolmachev Nikolay A · Anchorage, AKN78548Bakalar Flying Club Inc · Columbus, INN7854AMacglover Richard A · Ham Lake, MNN7854GNeuschaefer George H · White Hills, AZN7854ZAdams Jerry W · Dallas, TXN78553Shop Branch Equipment Co Inc · Marble Falls, TXN78556B&T Venutres LLC · Duncan, OKN7855CSitz Walter L · Burns, ORN7855FSmith Joshua B · Kenai, AKN7855GAlpenglow Air 3 LLC · Anchorage, AKN7855XBensema Amber L · Winchester, CAN7856FFitzgibbon Patrick D · Waterloo, WIN7856GMitchell Lindsey T · Chesnee, SCN7856XBrown Daniel F · Belgrade, MTN78579Hamilton George D · Bandera, TXN7857AEberhardt William J · Gig Harbor, WAN7857ELout James Mike · Jasper, TXN7857GAmerican Patrols Inc · Midland, TXN7857TDiamondhead Aero Co-Owners LLC · Picayune, MSN7857UMok Kuch · Delano, CAN7858EWhite Larry K · Pittsburgh, PAN7858FShelley Tiffany · Chandler, AZFirst renewal noticeN78590Obrien Connor J · Mulino, ORN78596Oshea Thomas F · Hamilton, NJN78598Schaefer Joseph P · Weyerhaeuser, WIN7859GAviators LLC · Casco, WIN7859UDuncan Martin R · Newark, ARN7859XGraves David E · Astoria, ORN785ASA S Flight Academy LLC · Lantana, FLN785BGVermont Flight Academy · South Burlington, VTN785BKPilot Peak Aviation LLC · Kalispell, MTN785ERTextron Aviation Inc · Wichita, KSN78603Beaufort Flight Training LLC · Beaufort, SCN78606Brook Trout Properties LLC DBA · Kalamazoo, MIN78607Jones John E Jr · Metter, GAN7860EBoomer Aviation Inc · Fort Walton Beach, FLN7860FVahary David J · Portage, INN7860GRoberts Timothy J Jr · Taylor, TXN7860ZGideon Troy J III · Elba, AL
Back to AD 79-10-14 R1