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.
N11209Pendragon Aviation LLC · Sylvania, GAN1121YShaw Michael B · Ridgeland, WIN11227Tribec Inc · Medina, OHN11228N11228 LLC · Wheeling, ILN11231He Yaling · Grand Prairie, TXN11234Universal Airways Inc · Richmond, TXN11236Cato Mark M · Clemson, SCN11238Laguna Ulises Edgar · Waco, TXN11242Crook Robert W · Wichita, KSN11243Aeronautical Technical Service Inc · Collierville, TNN1124QDuren Virgil W · Bristow, INN11251Air Flight Enterprises Inc · S Daytona, FLN11257Sale Reported · Eden Prairie, MNSale reportedN11262Locke Brian T · Andover, KSN11268Bohl Howard M Jr · Long Beach, CAN11272Williamson Brett O · Essex, MON1127YWong David · Torance, CAN11281Solovjev Jadranka · Sarasota, FLN11283J F Aviation Inc · Joliet, ILN11285Northeast Florida Aero Club Inc · Fleming Island, FLN11289Phelps Aero Co LLC · Salem, ORN1128YPerez Donna · Chico, CAN11290Safety In Motion Flight Center Inc · Puyallup, WAN11295Bancroft David J · Rio, WIN11297Raley James C · Brandon, SDN11299Creech John M · Brentwood, TNN112GBN112gb LLC · Oldsmar, FLN112LDMartin Joseph S · Carrollton, KYN112LNBruce James W · Searcy, ARN112NBCarew Enterprises Inc · Appleton, WIN11305Logsdon Elizabeth M · Morganfield, KYN11308Kaher Kevin G · Menlo Park, CAN11322Creekside Speech Therapy LLC · Ocala, FLFirst renewal noticeN11323Huckabay Timothy J · Red Bluff, CAN11329Burkhart Verlus L · Fairmont, MNN11331Gervais Andre B · Griffin, GAN11332Byrd Craig Stephen · Laurel, MSN1133MRobinson Lanis A · Clanton, ALN1133YGreen Mountain Semiconductor Inc · Burlington, VTN11351Lanier Equipment Leasing LLC · Gainsville, GAN11352Kimmel Nathan · Lancaster, PAN11353Denmark Brooks Mclaughlin · Clayton, NCN11356Melton Joseph W · Conway, ARN11358Lavalle David · Centerburg, OHN1135MLopez Ferco Capdevila · Port Saint Lucie, FLN1135YSwanson Isaac · Wasilla, AKN11363Fireland Christopher G · Brownwood, TXN11365Kimberk Frederick S · Cambridge, MAN11366Registration Pending · Jacksonville, FLRegistration pendingN11367Canniff Dustin P · Sutton, AK
Back to AD 75-15-08