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.
N809EMDepartment Of Homeland Security · Washington, DCN809GTDepartment Of Homeland Security · Washington, DCN809HWDepartment Of Homeland Security · Washington, DCN809KPDepartment Of Homeland Security · Washington, DCN809LNDepartment Of Homeland Security · Washington, DCN809NDDepartment Of Homeland Security · Washington, DCN809PGDepartment Of Homeland Security · Washington, DCN809QJDepartment Of Homeland Security · Washington, DCN809RHDepartment Of Homeland Security · Washington, DCN809SEDepartment Of Homeland Security · Washington, DCN809STDiaz Natanael Luna · Toa Baja, PRN809TTDepartment Of Homeland Security · Washington, DCN809USDepartment Of Homeland Security · Washington, DCN809VADepartment Of Homeland Security · Washington, DCN80AARegistered aircraftFirst renewal noticeN80BFAir Future Airways Corp · Miami, FLN80CAThomson Ian W · Anchorage, AKN80CRRdp Construction LLC · Sitka, AKN80DTTerasaka Kotaro · Moab, UTN80FPCarastro Enterprises LLC · Montgomery, ALN80GWSnyder Michael P · Las Vegas, NVN80HHoward Roland Dean · San Antonio, TXN80HXAthans Holdings LLC - Series 180 · Lake In The Hills, ILN80JWMorgan Philip H · Anchorage, AKN80LULetourneau University · Longview, TXN80MTMeloche Michael S Trustee · Hamilton, MTN80MWOlde North Church LLC · Wilmington, DEN80NInternational Air Services Inc Trustee · Carson City, NVN80PELakepoint Aviation LLC · Augusta, KSN80PPN80pp LLC · Titusville, FLN80RMMcguigan Robert J · Green Cove Springs, FLN80RXMccord Cheryl · Kuna, IDN80SGFerland Henry L III · Vidalia, GAN80SMSkyward Aviation Enterprises LLC · Raleigh, NCN80WCAir-Quip LLC · Boulder City, NVN80WTOtter Creek Lodge LLC · Big Timber, MTN8100SHigh Exposure Inc · Wilmington, DEN8101LRegistration Pending · Minden, LARegistration pendingN8101UWeirick Kelly M · Morganton, NCN8101XBreuer Elizabeth · Horseshoe Bend, IDN8102ABuck Randall J · Greenfield, INFirst renewal noticeN8102FFerrier Robert Clifford · Lindsay, CAN8102MShannon Michael E · Richland, WAN8102ZCrestview Estate LLC · Greenwood, SCN8103ACronk Kenneth B · Woodrow, CON8103BJafar Farid G · Pine Bluff, ARN8103LSoaring Mrt LLC · Lake Charles, LAN8103ZProsser Joel R · Sacramento, CAN8104BRomar Mark A · Massillon, OHN8104FDunham John P · Colorado Springs, CO
Back to AD 79-10-14 R1