AD 2012-09-10
Registered aircraft · 3,894
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:2012-09-10')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-09-10')
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:2012-09-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-09-10') 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.
N1079DGuardian Flight LLC · Lewisville, TXN1079UTurbines Ltd · West Point, NEN107CANorth Applicair Corp · Panama City Beach, FLN107KAN107ka Inc · Addison, TXN107SLSouthwest Aviation Specialties LLC · Tulsa, OKFirst renewal noticeN1083SGuardian Flight LLC · Lewisville, TXN1086FAvion Capital Corp · Anchorage, AKN108ALRj Flight LLC · Saint Petersburg, FLN108CRCambridge Investment Group Inc · Fairfield, IAN108KKSafety First LLC · Missoula, MTN108MKMikelly Aircraft LLC · Portland, ORN108RFRandigo LLC · Wilmington, DEN108RJDixon John W · Aurora, ORN1095WEaglemed LLC · Wichita, KSN109CLAircraft Structures International Corp · Enid, OKN109MDM B Duncan Inc · Bakersfield, CAN109MSCavallino Rampante Inc · Dover, DEN10BBFayard Enterprises LLC · Wake Forest, NCN10DHVta Capital LLC · Ontario, CAN10EAEagle Air Transport Inc · Ottawa, ILN10GFBank Of Utah Trustee · Salt Lake City, UTN10JAAircraft Structures International Corp · Enid, OKN10STGocc Blue Sky LLC · Augusta, GAN10WG10wg LLC · Newman Lake, WAN10YPBmf Jax LLC · Jacksonville, FLN11Federal Aviation Administration · Oklahoma City, OKN1103GMcn-Air LLC · Macon, GAN110DMColville Holding LLC · Anchorage, AKN110PEMission Aviation Fellowship · Nampa, IDN110PMCcp Air LLC · Norwalk, OHN110XXMegair Ventures LLC · Oklahoma City, OKN1110KPeach Air Corporation · Wilmington, DEN1114AEvans David J · Parker, CON1114KRogers John Stuart Trustee · Hughson, CAN1114ZCarefree Air LLC · San Jose, CAN1115MPa1 208b-0356 LLC · Fort Lauderdale, FLN1116GAircraft Structures International Corp · Enid, OKN1116WAvion Capital Corp · Anchorage, AKN1117GBrylee Investment Corp · Wilmington, DEN1119VMartinaire Aviation LLC · Addison, TXN111AABlue Water Aviation LLC · Vestavia, ALN111KULot-A-Go Six LLC · Polson, MTN111MQBismarck Air Medical LLC · Bismarck, NDN111MZCrb Companies LLC · Tulsa, OKN111RCSpiga Aviation Inc Trustee · Wilmington, DEN111RFEaston Air LLC · Middletown, RIN111VRDftf LLC · Des Moines, IAN111WGAhuva LLC · Port Alsworth, AKN111XARegistered aircraftN111ZZKnight Wings LLC · Matthews, NC
Back to AD 2012-09-10