AD 2012-17-06
Registered aircraft · 2,157
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-17-06')
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-17-06')
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-17-06') 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-17-06') 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.
N2DVLewis Paul A · Spring, TXN2RTBarnett Keri Trustee · Brownfield, TXN2SVPiper J D · Lawrenceville, ILN3030WZadnik Gary R · Vacaville, CAN309WPMcmahon Peter · Brookfield, CTN313MWClover George S · Catheys Valley, CAN31WHDerbecker David G · Katy, TXN320JLInspired Oasis LLC · Salem, ORN3228PPopejoy Marc · Fort Scott, KSN322JK & M Aviation LLC · West Liberty, KYN325CVajdos Nicholas · Karnes City, TXN330JGCultra LLC · Naples, FLN333CBSecondary Minimums Task Force LLC · Kalispell, MTN333CXFlying Bs LLC · Canby, ORN33DNRegistered aircraftN33PHPine Creek Adventures Inc · Benton, PAN344TXCline Lyndi · Royce City, TXN345HPMarek Gary A · Lemont, ILN346RMHansen Alexander G · Glendale, CAN354PCLund Vern E · Madera, CAN3632PAerospace Trust Management LLC Trustee · Wilmington, DEN36RDProflight Inc · Wilmington, DEN3764XAerialsmith LLC · Dunedin, FLN3783Midwest Fling Service Inc · Elgin, NEN37HEBjbipbip Corp Trustee · Wilmington, DEN38AGBaxter Kyle W · Tumwater, WAN397PCPapadopoulos Gustave · Summerland Key, FLN3HMTalley John T · Clifton, TXN3HRDow Glendal R Trustee · Bedford, TXN3MSCarter Zac · Atlanta, GAN3SDDanish John S · Hooksett, NHN3SGN3sg Enterprises Inc · Wilmington, DEN40193Rearden Logic Inc · Denver, CON409LAAnderson Wilma (Lori) · Blue Mound, ILN40JSAir Flight Enterprises Inc · South Daytona, FLN40RSSaul Gregory D Jr · Glenrock, WYN40VKSimply Living LLC · Fort Myers, FLN417BHHugel Bohdan · Selma, NCN41AEBowen Haldor S · Sandpoint, IDN41LPulliam Oscar E Jr · Moscow, TNN4236PRegistration Pending · Chandler, AZRegistration pendingN4250Leafgreen Jeff A Trustee · Lander, WYN4284Clements Eric C · Sheridan, WYN430MMMersereau Iden H · Goodyear, AZN431ABAirtrust LLC - 18 - Series 18 Trustee · Sheridan, WYN434BBElgin Engineering LLC · Arlington, TXN43TLT M L Aircraft Inc · Narrowsburg, NYN4483CRich Aden Gene · Sequim, WAN44PCGenocchio Anthony F · New Port Richey, FLN4563VMercer Alexander David · San Diego, CA
Back to AD 2012-17-06