AD 2012-10-52
Registered aircraft · 2,750
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-10-52')
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-10-52')
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-10-52') 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-10-52') 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.
N218CCSotally Tober LLC · Wilmington, DEN218SGMg Air Ventures LLC · Tucson, AZN219BTDacy Justin A · Boerne, TXN219CSFlorida Department Of Law Enforcement · Tallahassee, FLN2202NAlcyone Trust Corp Trustee · Wichita, KSN2206RKahonees Travel Services LLC · Pleasanton, TXN2209RPilotsgirl LLC · Goldsboro, NCN220TJJaco Oil Co · Bakersfield, CAN220WBWells Propane Inc · Wells, NVN2210RCarroll James K · Paso Robles, CAN22121Registration Pending · Georgetown, TXRegistration pendingN2217RParke Mike D · Twin Falls, IDN221DWDm Private Aviation LLC · Kaukauna, WIN221JTThompson Joseph · Marion, INN22206Slater Craig W · Brick, NJN22232Engeseth James Jr · Parker, CON2223SDavis Aaron B · Lascassas, TNN2226RChampion Crane Service Inc · Des Moines, IAN222FGoddspeed LLC · Encinitas, CAN222LSLj Bickford Companies LLC · Wasilla, AKN222SGPacific Aviation Aircraft Management Inc · Fresno, CAN2234RJones Lennis William III · Rule, TXN2235SN2235s LLC · Overland Park, KSN2236RSouthern Skies Aviation Inc · Cedar City, UTN223SCSurdex Corp · Chesterfield, MON223TB416b Heritage Hills Dr LLC · Palm Harbor, FLN22412Time Flies LLC · Oak Brook, ILN2241RHappy Landings Aero LLC · Wilmington, DEN2241XMandes George · Homer, AKN22459Hatch Leasing Company LLC · Flagstaff, AZN2246RMontgomery Brian · Houston, TXN2247SCarnes Andrew P · Wichita Falls, TXN2248RVan Heemst Jeffrey A · West Palm Beach, FLFirst renewal noticeN2249SDlw Flight Services LLC · Waterloo, ILN224CSAtb Special Purpose LLC · Laredo, TXN224KAChambers William Melvin Jr · Azle, TXN224PKValiair Lc Trustee · Casper, WYN2252RStout Walt · White Hills, AZN2252SSpider Lips Aviation LLC · Fischer, TXN2255HWinged Vision Inc · Gaithersburg, MDN2255MCooper Gary D · Fayetteville, ARN2259RLarson Lianne N · Irvine, CAN2259SFaireyfam Aviation LLC · Saint George, UTN225EBEbac LLC · Wichita, KSN225METvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN225VPAerotrust Services Corp Trustee · Wilmington, DEN2260SWheeler Eugene N · Livermore, CAN2261RPetik Jason P · Sidney, NEN2262SKoch Phillip E · Eldon, MON22650Sackett Gary G · Millcreek, UTFirst renewal notice
Back to AD 2012-10-52