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.
N113WYRyals Barry · Rhine, GAN1140QLuken Henry G III · Chattanooga, TNN1140XReaper LLC · Britton, MIN1142QSteely Paul · Williamsburg, KYN1144XFly Texas Sky LLC · Arlington, TXFirst renewal noticeN1144ZBay Lux Ventures LLC · Tampa, FLN1146HLtk Air Inc · North Wilkesboro, NCN1147HSpacious Skies LLC · Overland Park, KSN1147XPax Flyers LLC · Hollywood, MDN114CFAw Chartering LLC · Franklin, TNN114ELNaperville Flying Club · Woodridge, ILN1150XVenture North Aviation LLC · Cloquet, MNN1154XKelley Jay D · Lake Havasu City, AZN1157XAscend Aviation LLC · Bountiful, UTN1158HOs Flight LLC · Double Springs, ALN1159XBarrett Tyler J · Cullman, ALN115CSBurger Aviation LLC · Brandon, MSN115DCLong Jerry D · Solvang, CAN115DXPiper Aircraft Inc · Vero Beach, FLN115HPCam Aviation LLC · Valparaiso, INN115JAFarmer Stephen E · Tullahoma, TNN115TWYale Companies LLC DBA · Indianapolis, INN1160UPiper Aircraft Inc · Vero Beach, FLN1160XWagner Robert J · Dubuque, IAN1161HEngert Armin L · Kahului, HIN1161XBarnett Donald R · Atoka, TNN1163XPerry Curtis · Klamath Falls, ORN1164XRegistered aircraftN1165XLechtenberg Lance · El Dorado, KSN1167XHoover Adam A · Sugarloaf, PAN1168XJz Air LLC · Brooklyn, NYN116AVValleortiz Hector J · Laurel Hill, NCN116BKDacy Roy W · Rockport, TXN116FRCloverfield Aero LLC · Los Angeles, CAN1177AN1177a LLC · Lewes, DEN1177XParrish View Farms · Kenbridge, VAN1178XN1178x LLC · Dover, DEN1179XDesch Edward J III · Aldie, VAN117BCGiardina Edward Charles Jr · Cranston, RIN117CSSam Airlines LLC · Wilmington, DEN117DBHawley Vance L · Idaho Falls, IDN117DWFerrand Kathy M · Cornelia, GAN117GHAircraft Guaranty Corp Trustee · Oklahoma City, OKN117HWYale Companies LLC DBA · Fishers, INN117JCHillsboro Flying Club · Hillsboro, ORN117MBLittmarck Svante · Dedham, MAN117MTHinkle Robert J · Caldwell, IDN117TKWindstar Air LLC · Carroll, IAN117VRAtmospheric Vehicle & Spacecraft Flght Exploration · Rch Palos Vrd, CAN1180XK & K Aero Inc · Wilmington, DE
Back to AD 95-26-13