OpenAirDocs.org
AD 95-26-16 R1

Registered aircraft · 1,406

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-16-R1')
    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-16-R1')
  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.

N40XXRegistered aircraftBuilt 1993 · S/N 24-3306N41007Registered aircraftBuilt 1991 · S/N 243220N4100HTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1980 · S/N 24-1029N4102HForeman Guy W · Valparaiso, INBuilt 1978 · S/N 240617N4105HBonanza Valley Air LLC · Alexandria, MNBuilt 1978 · S/N 24-0621N4110HKoerkenmeier James J · Carlyle, ILBuilt 1978 · S/N 24-0626N4112HGroves Carl Jr · Lebanon, TNBuilt 1978 · S/N 24-0627N4113HWettstein Tim · Manhattan Beach, CABuilt 1978 · S/N 24-0628N4114HSemeniuk Steven Ty · Houston, TXS/N 24-0629N4122HBeck Randy R · Claremont, CABuilt 1978 · S/N 24-0645N4124HTyler Patrick E · Poplar Grove, ILBuilt 1978 · S/N 24-0637N4125HOsterbeck Jeffrey A · Jackson, WIBuilt 1979 · S/N 24-0771N4128HLehnert Jaxon C · Turpin, OKBuilt 1978 · S/N 24-0642N4138HMiller John A · Ballston Lake, NYBuilt 1978 · S/N 24-0643N4148HRegistered aircraftBuilt 1978 · S/N 24-0647N4152HMountain West Aviation LLC · Denver, COBuilt 1979 · S/N 24-0770N4164HRobertson James I · La Pine, ORBuilt 1978 · S/N 24-0623N4171HHanson Zane · Danville, INBuilt 1978 · S/N 24-0653N4182HAir Superiority Inc · Syracuse, NYBuilt 1978 · S/N 24-0656N4192HBrown Joel M · Kokomo, INBuilt 1978 · S/N 24-0660N4199HN4199h Club Llp · Oshkosh, WIBuilt 1978 · S/N 24-0661N4201LSuverkrup Mark · Columbus, INBuilt 1978 · S/N 24-0572N4201UEclipse Air LLC · Versailles, MOBuilt 1978 · S/N 24-0574N4211HRn Roofing LLC · Brandon, MSS/N 24-0662N4212HG And H Aviation · Louisville, KYBuilt 1978 · S/N 24-0663N4218HGenna Aviation LLC · Newfield, NJBuilt 1978 · S/N 24-0665N4220HHutchinson Keith M · Lancaster, TXBuilt 1978 · S/N 24-0666N4222Barry Edwin R · Apple Valley, CAS/N 24-0655N4222HCre Aviation Holdings LLC · Ramona, CABuilt 1978 · S/N 24-0667N4227HMccharters LLC · Hobe Sound, FLBuilt 1978 · S/N 24-0670N4232HHupp Garrett · Sunbury, PABuilt 1978 · S/N 24-0671N4234HKacprzak Dominik · Kingwood, TXBuilt 1978 · S/N 24-0673N4235HJunker Gregory G · Cincinnati, OHBuilt 1978 · S/N 24-0676N4239HGray Steven Don · Tualatin, ORBuilt 1978 · S/N 24-0678N4244HLeung Henry C · Simsbury, CTBuilt 1978 · S/N 24-0679N4247HRimensberger Boris D Trustee · Fullerton, CABuilt 1978 · S/N 24-0680N4248HGay Arnash · Harrison, OHBuilt 1978 · S/N 24-0681N4256HJeffers Chadwick Ray · Glencoe, ALBuilt 1978 · S/N 24-0685N4258HCeason Jeffrey M · Tucson, AZBuilt 1978 · S/N 240686N4262HNorthern Iowa Anesthesia Services P L C · Ames, IAS/N 24-0688N4267HGmt Enterprises LLC · Stephenville, TXFirst renewal noticeBuilt 1978 · S/N 24-0690N4269HSiniakin Michael K · East Brunswick, NJBuilt 1978 · S/N 24-0692N4273HWooten William E Jr · Taft, TNBuilt 1979 · S/N 24-0772N4289HGiguere Michael R · Danielson, CTBuilt 1978 · S/N 24-0696N4293HHelleberg John R · Centreville, VABuilt 1978 · S/N 24-0697N4297HAirswiss Inc · Wilmington, DEBuilt 1978 · S/N 24-0699N4305HTylski Aero Services LLC · Valley, NEBuilt 1979 · S/N 24-0788N4322H4322h Rescue LLC · Oakland Park, FLS/N 24-0822N4323HRucker Edward A · Longview, TXS/N 24-0704N4328HCalabretta Charles J · Hanford, CABuilt 1978 · S/N 24-0708
Back to AD 95-26-16 R1