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.
N11527Red Oak Commuter LLC · Red Oak, IAN11528Streeter Derek · Guilford, CTN11529Registration Pending · Mattituck, NYRegistration pendingN11531Ireland Lois Trustee · Herndon, VAN11533Neal Robert J · Martinsville, INN11534Litzau Melissa · Lake Lillian, MNN11538Fallon James R · Chestnut Hill, MAN11540Eddleston Ryan · Winter Haven, FLN11546De Souza Alex Henrique · Newark, NJN11552Dunn Ashley L · Mc Alpin, FLN11554Groux Robert E Jr · Spring, TXN11558Cwi Air Motive Inc · Grant Park, ILN11561Marsh John E · Washington, DCN11563Hunnewell Aviation Services Inc · La Crescent, MNN11569Cornejo Jose Valente · Scottsdale, AZN11570Wilson Steven J · Elkton, KYN11571Sale Reported · Spokane, WASale reportedN11573Airfleet Solutions LLC · Newark, DEN11577Tre Aviation Corp · Wilmington, DEN1157YMoles Dale A · Mooresburg, TNN11587Stark Avionics LLC · Panama City, FLN11589Harbert Gary J II · Newville, ALFirst renewal noticeN1158YAas LLC · Ovid, MIN11590Ramaswamy Gautam · Clearwater, FLN11592Vu Ai Thi · Aiea, HIN11594Reynolds Eugene II · Gastonia, NCN1159YAultman Micah · Rocky Face, GAN115MRRussell Keith M · Ivoryton, CTN11605Airelectric Inc · Tulsa, OKN11607Cutrubus James G DBA · Ogden, UTN11610Jensen Greg D · Omaha, NEN11616Registration Pending · San Bernardino, CARegistration pendingN11619Lewis Billy D · Cleveland, GAN11621Hopkins Josh · Corpus Christi, TXN11626Frantz Ellen C · Abbeville, GAN11628Monon Bell Aviation LLC · Brownsburg, INN1162YBryan Danny J · Hobbs, NMN11634Ryan Leo A · Jamestown, NDN11639Tubb Terry L · Centerton, ARN1163YWyatt Airventures LLC · Ogallala, NEN1166YPositive Painting Inc · Lakeland, FLN1169YSkuza Patrick · Soldotna, AKN116FTaylor John · Mammoth Spring, ARN1170YMacmullen Kenneth P · Quakertown, PAN11731Dupree Wesley W · Molena, GAN11732Lewis Nathan Alan · Crestline, CAN11738Tat Networks And Aviation LLC · Bend, ORN11746Flying Panthers Flight School Inc · Citrus Heights, CAN11748Kilber Ronald P · Salome, AZN11749Adams Chad R · Joplin, MO
Back to AD 75-15-08