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.
N7393MJ S Imperio Construction And Real Estate Svc/S LLC · Laredo, TXN7393TAppalachian Flight Services LLC · Huntington, WVN7393XSmokovitz Joseph M · Tecumseh, MIN73946Carastro Enterprises LLC · Montgomery, ALN7394AFreer Lawrence C III · Puyallup, WAN7394NPritchett Randal M · Kingfisher, OKN7394SFourcher Fredric · Corona Del Mar, CAN7394TSmith Lowell A D · Gresham, ORN7394XRinehart James A · Sebring, FLN7395DAviation Management Group LLC · Endicott, NYN7395ERegistered aircraftN7395GBrewer James · Myakka City, FLN7395HWild Alaska Real Estate LLC · Anchorage, AKN7395SJamison Russell D · Quinter, KSN7395TWhalen John F Jr · West Ossipee, NHN73964Coachron Investments LLC · Grosse Ile, MIN7396NAd Astra Aviation Services LLC · Saline, MIN7396QBoling Justin · Eureka, MON7396SThomas James H Jr · Boulder, CON7396TFitzsimmons Robert J · Hastings, FLN7396UAlaska Aircraft Leasing LLC · Silverdale, WAN7396XJons Steven R · Minden, NEN73977Bfl Aviation LLC · Bakersfield, CAN7397AWillems Scott F · Cottonwood, CAN7397GMarkowitz Edwin P · Luray, VAN7397MBuck Mark E · St Maries, IDN7397QCabral Jesse J · Whitethorn, CAN7397SRaynor Rhett A · Dunn, NCN7397TDirectional Holdings LLC · Missoula, MTN73981Gagnon Michael J · Merrimack, NHN7398EGriffith John M · Seatac, WAN7398SWilson Todd C · Camp Verde, AZN7398THilliard George W · Beeville, TXN7398XSnodgrass James T · Gallipolis, OHN7399AWheeler James H · Bryan, OHN7399ETenney Curtis J · Sevierville, TNN7399QStc Group LLC · Westlake Village, CAN7399TLandrover Ltd · Hills, MNN739ADSeven Three Nine Alpha Delta Club Inc · Memphis, TNFirst renewal noticeN739AFSilver Isaac M · Satellite Beach, FLN739AGS O W Aviation LLC · Crystal River, FLN739AJAviation Adventures LLC · Billings, MTN739AKChen Wu · West Windsor, NJN739ALFly Rite Aviation LLC · Fort Myers, FLN739AMBartels Michael · San Antonio, TXN739APMilwaukee Aero LLC · Milwaukee, WIN739AQAzure Mahpiya LLC · Dublin, CAN739ATSocal Aviation Inc · Chino, CAN739AVMk914 Aviation LLC · Boynton Beach, FLN739AWOsborn Lawanda H · Weatherford, TX
Back to AD 79-10-14 R1