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.
N400WLHammer Construction Corp · Miami, FLN400YKarschney Rich · Seattle, WAN40193Rearden 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, CAN456PBooth Donald V · Denison, TXN45888D-Five Holdings Group LLC · Vidor, TXN45MBWright Kelly A · Spokane, WAN46MJones Gregory D · Pueblo, CON46PHarrison Donna J · Eau Claire, MIN478WTBas Part Sales LLC · Greeley, CON47BBRogers Joseph O III · Fernandina Beach, FLN487SCRegistered aircraftN4960250 Inc · Washington, DCN4995BStobbe Marlin L · Granada Hills, CAN4CBDream Catcher Company LLC · Center, CON4PLJuliet Kilo Aviation LLC · Palos Heights, ILN4XNMiller Donald W · Harrisonburg, VAN5002POrtman Bernard · Deer Park, TXN5003PLouwagie Bradley J · Marshall, MNFirst renewal noticeN5005PRackley William R Jr · Grand Island, FLN5006PWright William · Cleveland, OKN5008PThree Chicks Aviation LLC · Benton, LAN500AVInternational Air Services Inc Trustee · Carson City, NVN500PFord Charles D · Clifton, TNN5014PSky Valley Aviation LLC · Waverly, IAN5017PPineapple Air LLC · Wilmington, DEN5020PThurston Steven C · Salisbury, NCN5029PJordan Walter B · Chehalis, WAN5034PNeufeld William J · Bostwick, FLN503JALiem David H · Brea, CAN5045PMccarty Paul S · Wichita, KSN5048PBrown Mark E · Charlotte, NCN5050PBoucher Bobbi · Fredericksburg, VAN5051PGrorud James R · Milbank, SD
Back to AD 75-12-06