AD 75-15-08
Registered aircraft · 10,106
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-15-08')
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-15-08')
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-15-08') 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-15-08') 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.
N11369Abrams Adrian L · Palmer, AKN1136MHiggins Derrick · Arbyrd, MON11371Sale Reported · Thomaston, GASale reportedN11373Huffman Aviation LLC · Burleson, TXN11380Roush Daniel E · Shoals, INN11387Cloud Nine Aviation Inc · Picayune, MSN11389Swinnich Kenneth · Wellsboro, PAN1138ZMuffoletto Matthew · Anchorage, AKN11392Verrill John B · Shelburne, NHN11393Brough James P II · Nashua, NHN11395Coleman Darryl W · Fayetteville, GAN11396Jeffries Holdings LLC · Bargersville, INN11397Nydam Adam Adrian · Lawrenceburg, KYN11399Registered aircraftN-number assigned, not yet registeredN113NDFox Flight Instruction LLC · Jacksonville, FLN11402Mcdowell Charles R II · South Charleston, WVN11405Cornelius Steven E · Wasilla, AKN11407Harrop Brian · Mesa, AZN11409Cambium International Inc · Cary, NCN1140YPritchard Casey M · Bells, TXN11410South Florida Helicopters Inc · Indiantown, FLN11416Woodward Stephen W · Westfield, NYN11430De Alwis Godalle W · Riverside, CAN11433Jedi Flight Training LLC · Boerne, TXN11442Burkholder Donald R · Kent, OHN1144YThomas Douten D · Roxbury, MEN11452Schatz Michael J · Myerstown, PAN11454Wausau Flying Service Inc · Wausau, WIN11460Kalmar Peter · Suquamish, WAN11479Lucky Duck Aviation LLC · Palm City, FLN11485Foster Harold · Natchitoches, LAN11488Cooker Keith P · Greenville, SCN1148TCorlett Samuel E · Fort Worth, TXN11491Jamieson Donald R · Condon, ORN11492Mccroan James H · Altha, FLN11493Wajih Al Habbal · Simi Valley, CAN1149911499 LLC · Oklahoma City, OKN114SIrby Darrell L · Keller, TXN11501Erickson Kirk E · Warroad, MNN11507Strickland Jed B · Bald Knob, ARN1150LNida Kevin R · Santa Paula, CAN1150YHoffman Anthony J · Rathdrum, IDN11510Falls Aero Inc · Great Falls, MTN11513Erickson Tristan Scott · Port Townsend, WAN11514Kickstart Aviation LLC · Mayfield, KYN11517Grier Robert M · Deland, FLN11519Kap Title Inc · Tucker, GAN1151BOrtiz Daniel · Edinburg, TXN1151XSummers Jayson V · Poway, CAN1151YCraigmyle William R · Cooperstown, NY
Back to AD 75-15-08