AD 95-26-13
Registered aircraft · 21,464
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:95-26-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-13')
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:95-26-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-13') 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.
N15406Apollo Flying Club LLC · Nashua, NHN1540JGray Caleb · Henderson, NVN15410Simpson Randal L · Missouri City, TXN15414Registration Pending · Milaca, MNRegistration pendingN15417Coburn Kyler J · Mountain Home, IDN1541CSwan Russell · Glenside, PAN1541JNauhaus Samuel W · Concord, NCN1541XSheffer Marshall A · Herrin, ILN15422N15422 LLC · Cortland, NYN15423Gerken Scott G · Sharpsburg, GAN15426Piper Pilots LLC · Wilsonville, ORN15435Crown Aviation LLC · Haltom City, TXN15438Max Motors LLC · Encino, CAN1543JKosmin Vladimir · Delta Junction, AKN15442Buchanan Ethan D · Au Gres, MIN15446Josephson Don C · Sidney, MTN1544JRidgway Rick J · Carlisle, INN15450Berndt George A · Napa, CAN1545JVandorn Marcus A · Neosho, MON15470Nolin Jesse · Samson, ALN15471Sport Air Inc · York, PAN15472Wild Wingdom LLC · Greenville, SCN15473Cerniglio Dominic Antonio · Sebastopol, CAN15475Ortega Chris A · Santa Fe, NMN15476Lengacher Caleb Lee · Montezuma, GAN1547XKoch Steven T II · Brownsburg, INN15483Tnj First Class Flying Properties LLC DBA · Dallas, TXN15484Thompson Mark L · Kirksville, MON15489Black Knights Transportation Services LLC · Garden Grove, CAN1548XSouthern Turf Services LLC · West Palm Beach, FLN15493Midwest Flying Service Inc · Elgin, NEN15494Freisitzer Roland Franz · Charlottesville, VAN15498Universal Management And Mainteneance Co Inc · Enid, OKN15499Lankford Toby C · Canadian, TXN154ARPiper Aircraft Inc · Vero Beach, FLN154AVDaviation Inc · Willoughby, OHN154BJDent Air Ltd · Annapolis, MDN154DCRocha Jonathan · Prescott Valley, AZN154ERN154er LLC · Kissimmee, FLN154FTMiloud Chadd K · Fort Worth, TXN154PAParagon Airplane Leasing Co · Fort Myers, FLN15504N15504 LLC · Eatontown, NJN1550XVictors Vectors LLC · Valparaiso, INN15510Lok Kevin K · Upper Sandusky, OHN15514Smedsmo Darrin A · Roseau, MNN15517Little Ralph D · Rockwall, TXN15518Registration Pending · Concord, CARegistration pendingN1551SVoelker Craig C · Mount Pleasant, IAN15523Derryberry Clay · Lewisburg, TNN15524Brown Gerald · Apple Valley, MN
Back to AD 95-26-13