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.
N1181HAdams Dustan David Sr · Houma, LAN1184DZwick Noah Geary · Dunkirk, MDN1184XLairson Samuel E III · Ocean City, NJN1185HJcaviator LLC · Matthews, NCN1185XWilliamson Flying Club Inc · Williamson, NYN1188TAbrams Jeffrey Scott · Phoenix, AZN1188XSteven H Baker Construction Co · Big Bear City, CAN118BJOn Final Aviation LLC · Brookland, ARN118ESCmv Aviation LLC · Johnson City, NYN1190HBergman William George · Muskegon, MIN1191HBurford John W Trustee · Madison, MSN1196XMedic Choppers LLC · Springdale, ARN1198HAlge Aviation · Middletown, DEN1198XDiscover Aviation Center LLC · Elyria, OHN119A2is Partners LLC · Vero Beach, FLN119AVFour Mac Air LLC · San Diego, CAFirst renewal noticeN119BTDelaware US Investments LLC · Corpus Christi, TXN119GSDall James R Jr · Hayes, VAN119HPValiair Limited Company Trustee · Casper, WYN119JDUSA Wiltshire LLC · Pembroke Pines, FLN11CASky Dragon LLC · Atlanta, GAN11CWJabez Aviation LLC · Petaluma, CAN11FLBell Christopher K · Ashley, OHN11GERusso James F · Liberty, SCN11GKBaden Michael · Waxhaw, NCN11GNHaley James M Trustee · Edmond, OKN11HAVintage Aero Inc · Brandon, FLN11HKJohnson Wendell F · Harlingen, TXN11JUPottorff Gregory K · Wayne City, ILN11KAlbers Edward C · Burlington Flats, NYN11KXN11kx LLC · Santa Clara, CAN11LYBishop Jay K · Columbus, INN11NTSabb Anthony · Wetumpka, ALN11UZEastern Stearman Inc Trustee · Leesburg, VAN11YTAnm Air LLC · Grimes, IAN1203TProfessional Locators & Acquisition Specialists Ll · Severance, CON1204THigh Sky LLC · Ellensburg, WAN1205TAmerican Aircraft Management LLC · Irving, TXN1206TCps 1 LLC · Pelham, ALN1207HVenture West LLC · Mesa, AZN1208HWaldel Ltd · West Lafayette, INN120CDJackson Farms Callahan Division LLC · Callahan, FLN120DGBluesail LLC · Las Vegas, NVN120DMWestfall Aviation LLC · Reno, OHN120MGParagon Airplane Leasing Co · Fort Myers, FLN120PWBrookhaven Aviation LLC · Brookhaven, MSN1213TDyer Gary T · Reno, NVN1214TPost 8 Flight Opps Inc · Topeka, KSN1216TOlsen Christopher D · Bothell, WAN1217TSauer Roger A · Glenburn, ND
Back to AD 95-26-13