AD 75-12-06
Registered aircraft · 2,232
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:75-12-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:75-12-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:75-12-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:75-12-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.
N29BJMax Total Time LLC · Lufkin, TXN29SCBrown Sherrie C · Cushing, OKN2ABBailey Richard T · Oregon City, ORN2DVLewis 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, DEN400CJDeepe Mark D · York, NEN400EDavis Richard · Reno, NVN400FKFinazzo Joseph · Fort Mohave, AZN400FW400fw LLC · Largo, FLN400GCNorthern Sky Aviation LLC · Harbor Springs, MIN400GUTriple S Aviation LLC · Wilmington, DEN400HLSale Reported · Lamesa, TXSale reportedN400HPMorgan David W · Canton, MIN400HRDavis Gary L · Burleson, TXN400KKDennehey Patrick N · Cameron Park, CAN400NQN400nq LLC · Gleeley, CON400PAN6105s LLC · Norwood, NCN400PPMig Aviation LLC · Sandy, UTN400SWDay Stephen F · Queen Creek, AZN400WGRegistered aircraft
Back to AD 75-12-06