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.
N206PQHogue LLC · Paso Robles, CAN206RAAcord Transportation Inc · Chandler, OKN206RCPaloma Aviation LLC · Fruitland, IDN206RPFinley Aviation LLC · Fort Worth, TXN206RR206 Adventures LLC · San Juan, PRN206SJUrbana Aviation LLC · Woodstock, OHN206SNDye Seed Ranch Inc · Spokane Valley, WAN206TBAir Supply LLC · Tuscumbia, ALN206TZTeton Leasing LLC · Polatello, IDN206UESmith Peter I Trustee DBA · Ocala, FLN206VBN206vb LLC · Batavia, OHN206VSBos Ranch LLC · Reno, NVN206WKKaw Corp · Mcallen, TXN206WPMorrison Richard Lee Trustee · Anchorage, AKN206WTSevere Clear Aviation LLC · Hagerstown, MDN206WYAerotrust Services Corp Owner Trustee · Wilmington, DEN206XKennedy Benjamin · Boulder, CON206XPAirborne Flyer LLC · Ashland, NHN206YPIm Aviation LLC · Laredo, TXN2070SThompson Robert V Trustee · Crawford, CON2076SWarden Air LLC · Warden, WAN207ALU S Imaging Flight Ops LLC · Bartow, FLN207BHElevation Squad Inc · York, PAN207CCAbaco Fire Rescue Association Inc · Lewes, DEN207DAKolb Austin · Phoenixville, PAN207DFDouble R Air LLC · Miami, FLN207DLRegistered aircraftN207GHBridgeview Aviation LLC · Southfield, MIN207GRBlue Sky Telluride LLC · Telluride, CON207SRJaars Inc · Waxhaw, NCN207TFPhotos Unlimited Inc · Rancho Cordova, CAN2083SDave Schmauderer · Woodland, CAN2084SSecondhand Flying LLC · Ogden, UTN2085SRichards John · Casa Grande, AZN208DGDelta Golf Aviation LLC · Pompton Plains, NJN208FT423 East Young LLC · Warrensburg, MON208WPCassidy Ryan H · Seattle, WAN2092SMidwest Airmotive Inc · Mount Sterling, KYN2095JAviation Trust Co LLC Trustee · Oklahoma City, OKN2095SMrk Aviation LLC · Delray Beach, FLN2099YThompson And Harvey Holdings LLC · Orcutt, CAN209CSMat Air LLC · Bridgeport, TXN20ADDdd Partnership · Davis, CAN20CNRegistration Pending · Bedford, PARegistration pendingN20HLCs&P Rocky Mountain Inc · Cypress, TXN2101ZPico'S Plane LLC · Rockport, MEN2109JRaf Ks LLC · Wichita, KSN210AAMeckley Sean H · Seattle, WAN210ABRudy Schmitt · Brookshire, TXN210ARVjc Air LLC · Katy, TX
Back to AD 2012-10-52