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.
N1276AAir Land Ventures 3 LLC · Berwyn, PAN127JEGillian Michael · Batavia, ILN1289UKavak Air Inc · Middletown, DEN1296MThacker Thomas L Trustee · Hurricane, UTN129ELTrooien-Smith Construction LLC · Seeley Lake, MTN12DUWoodtick Summit Aviation LLC · Redmond, ORN12PFRucker Gary R · Kingman, AZN1301LFox Aircraft LLC · Bethel, AKN130CPCivil Air Patrol · Maxwell Afb, ALN130DWAttoyac Air LLC · Gonzales, TXN130SJAircraft Guaranty Corp Trustee · Oklahoma City, OKN131DTAerownership North American Services Inc Trustee · Wilmington, DEN131TTCharlie Kilo Enterprises Inc · Melbourne, FLN1323DEl LLC · Center, CON1327EDeguerin Dick · Houston, TXN1327KLoveland Aviation LLC · Scottsdale, AZN13291Conspec Inc · Wichita, KSN1330GNorth Plains Honey Co LLC · Bozeman, MTN1331MRegistered aircraftN135GVreeland Equipment Rental LLC · Dayton, OHN135TSN135ts LLC · Lima, OHN13709Personal Wings Inc · San Diego, CAN137TSArk Aviation LLC · Moncks Corner, SCN139BBTrejo Nahomy · Socorro, TXN13KSNolt Ivan · Mount Solon, VAN13TNMcdaniel Robert M · Tonasket, WAN13WNRegistered aircraftN1410URuffcorn Aviation Co · Bettondorf, IAN141CPCivil Air Patrol · Maxwell Afb, ALN1423WMaricopa County Sheriffs Office · Phoenix, AZN143GBDocinator Aviation LLC · Edmond, OKN143GMNby Productions · Bristow, VAN143GSPxw Services · Bristow, VAN1447LHall Daniel W · Westlake Village, CAN144GRegistration Pending · Waco, TXRegistration pendingN144WPDresel Av LLC · Fayetteville, ARN1450CFreeland Christopher G · Brownwood, TXN1458HMosle Air LLC · Far Hills, NJN1460TJlj Aviation LLC · Amarillo, TXN147GWAllen Air LLC · Creola, ALN147PASetki Air LLC · Wilmington, DEN147SASteeda Autosports Inc · Pompano Beach, FLN147TXTexas Department Of Transportation · Austin, TXN1488TTanana Leasing LLC · Fairbanks, AKN148DWVantage Aviation USA LLC · Tampa, FLN1494CFour C'S Equipment Leasing LLC · Fresno, CAN149DWRbf Aero · Wilmington, DEN14JEN14je LLC · White Springs, FLN14NNAms Aviation LLC · South Bend, INN14WLTextron Aviation Inc · Wichita, KS
Back to AD 2012-10-52