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.
N777MBCullen Maryrose · Longmont, CON777NTN777nt LLC · Fort Mill, SCN777NYJohanson Jason M · Groveland, CAN777PTGrandair Aviation Inc · Grand Ledge, MIN777RKing Winn K · Gladewater, TXN777RGLow Matthew N · Clearwater, FLN777RRChalk 2 Inc · Apple Valley, CAN777SZMullen John J Jr Trustee · Henderson, NVN777TVTop Ag Inc · Colby, KSN777TWMcdonald Timothy J · Daytona Beach, FLN777UMMahlik Michael A · Casco, WIN777WLAerospace Trust Mangement LLC Trustee · Wilmington, DEN777WRFoley James V · Houston, TXN777ZCDiversified Refrigeration Co · Lino Lakes, MNN7780AWhitmore Jay R · Anchorage, AKN7780EBush Consulting Services LLC · Pensacola, FLN7780FDuquette Stephen R · Fenton, MIN7780GAero Quest LLC DBA · Olive Branch, MSN7780KRegistered aircraftN7780XRegistration Pending · Meridian, IDRegistration pendingN77812Wildman Gary C Trustee · Germantown, TNN7781EGibson Paul Trustee · Groveland, CAN7781GKelley Aircraft LLC · Weyers Cave, VAN7781TChouinard Shawn A · Collinsville, OKN7781UKerslake Alex J · Ellensburg, WAN7781XPeraro Thomas A · Brighton, CON7782FLewis Wayne · Martin, TNN7782KHaughee Jared · Warsaw, INN7782THicks Thomas H · Conway, ARN7782XBoucher Roberta Ann · Fredericksburg, VAN7783APhipps Laura P · Midland, TXN7783EMobile Aviation Solutions LLC · Sharpsburg, GAN7783FMiller Patrick G · Homer, AKN7783UEppich Glen M · Kingman, AZN7784FSelf Edwin C · Columbia, TNN7784GAll2fly LLC · Atlanta, GAN7784TJustonemore LLC · Fayetteville, ARN7785AZulu Forty One LLC · Anchorage, AKN7785UTwo Farmers LLC · Dumas, ARN7786GRcm Aviation LLC · North Clarendon, VTFirst renewal noticeN7786UWooton Donald Wayne · Houston, TXFirst renewal noticeN7787USageser Scott · Carmi, ILN7788AChambers Samuel S · Salmon, IDN7788FGerig David J · Woodburn, INN7788UHoffmeyer Scott D · Carson City, NVN7788XBowling John D · Bryan, TXN7789AMersereau David H · Anchorage, AKN7789BMersereau David H · Anchorage, AKN7789FSutton George R · Big Bear City, CAN7789UViolette David A · Medway, ME
Back to AD 79-10-14 R1