AD 75-09-08
Registered aircraft · 3,035
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-09-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-09-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-09-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-09-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.
N1344WVortex Aviation LLC · Biloxi, MSN1345WHendricks John E · Heber Springs, ARN1346WUnal Alper Cevat · Las Vegas, NVN1351WAllen Mark S · Reno, NVN1355WBloch Matthew William · Marquette, MIN1358WDavis Charles S · Fairfield Bay, ARN1359WKroll Richard · Laguna Niguel, CAN135JCNelson Bradley L · Portland, ORN1360WRiggs Aviation LLC · Heath, TXN1364WTriple B Properties Ltd · Aledo, TXN1367WSelover Richard D · Colusa, CAN1373WGarces Manuel E · Jefferson, GAN1374WWade Deborah D · Mineral Wells, TXN1375WAndrews Kevin M · Hermitage, TNN1376WMarling Russell Cole · Highlands, NCN1380WOverstreet Jeffrey D · Bentonville, ARN1381WReed Michael S · Sweetwater, OKN1384WTz Aviation LLC · Enterprise, ALN1388WM30c 2666 LLC · Jenks, OKN1392WSale Reported · Lakeland, FLSale reportedN1394WLuniewicz Morgan · Walnutport, PAFirst renewal noticeN1395WRienstra Andrew P · South Lyon, MIN1396WD & J Solutions Inc · Nokesville, VAN1397WMorris Michael E · Las Vegas, NVN13MDMoorstein Mark A · Manassas, VAN13TMSuntech LLC · St George, UTN14038Eagle Aviation And Logistics LLC · Cheyenne, WYN141TTActon Paul W · Blue Mound, KSN142EJAskwig Michael C · Lincoln, MIN142WHendry James W · Cortez, CON14483Amar John D · Las Vegas, NVN147EBMalott David · Glade Park, CON14TWAllbid Inc · Opelousas, LAN151DB1 Zero Sierra Whisky LLC · Helena, MTN160DPrice Paul L · Lancaster, VAN165AZBoyko Flying Services LLC · Ruso, NDN167LDRegistered aircraftN167QQGrondahl Chad R · Peyton, CON16DRHibner Christopher J · Canton, MIN175KTTurney Gerald E · Oakland, CAN177FDSale Reported · Bowling Green, KYSale reportedN177TCCaram John M · Saint Leonard, MDN17ACPressley Brent DBA · Morristown, TNN17ADOlear Daniel J · Warren, MIN17HTSund Kenneth · Edmonds, WAN17WJAngel Wings Flyers LLC · Wilson, NCN184JLPeters Bryan · Corpus Christi, TXN185DCWood Ronal D Jr · Clarksville, FLN187JWBriley Christopher P · Lynchburg, VAN187TATech Air LLC · Lexington Park, MD
Back to AD 75-09-08