AD 95-09-13

Registered aircraft · 1,061

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-09-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-09-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.

N495495htsi LLC · Wilmington, DEBuilt 1980 · S/N 414A0487N499ATN633at LLC · Punta Gorda, FLS/N 414A0306N499CAHyannis Air Service Inc · Hyannis, MABuilt 1985 · S/N 402C1006N4HAArrington Harold M · Detroit, MIBuilt 1984 · S/N T30300283N4JDLillian Aviation LLC · Cypress, TXS/N 421C1806N4MZBank Of Utah Trustee · Salt Lake City, UTS/N 421C0829N4VHFoster Chad H Jr · Uvalde, TXBuilt 1977 · S/N 421C0435N5000UMci Air LLC · Wilmington, DEBuilt 1979 · S/N 414A0318N501CLSalt Aerial Aviation LLC · Hamel, MNS/N 414A0339N502RARichland Aviation Inc · Sidney, MTBuilt 1977 · S/N 4040066N502SAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1978 · S/N 421C0520N505CNLes Amis Air LLC · Dorado, PRBuilt 1978 · S/N 414A0201N505LTLaufer Air Inc · Hartford, WIBuilt 1978 · S/N 421C0617N5091CMartin Steven J · Phoenix, AZBuilt 1982 · S/N T30300132N509RSHalf Shell Aviation LLC · Highlands Ranch, COBuilt 1978 · S/N 414A0060N50CBHughes Eugene F Jr · Butte, MTBuilt 1979 · S/N 414A0228N50LWildcat Aeroplanes LLC · Sedalia, COBuilt 1977 · S/N 421C0431N50MAGoodhue David H · Vancouver, WABuilt 1979 · S/N 414A0434N50ZPPalen Mark T Trustee · Cleveland, TNBuilt 1975 · S/N 421C0022N510NEAirswiss Inc · Wilmington, DEBuilt 1984 · S/N 402C1001N510SMGolden Leaf Tobacco Company Inc · Keysville, VAS/N 421C0112N512KZotec Partners LLC · Carmel, INBuilt 1978 · S/N 414A0054N5134CEzrydr LLC · Huntsville, ALBuilt 1982 · S/N 414A0852N513FSJackson Construction Services LLC · Wichita Falls, TXS/N 421C0510N513JNFly-Area LLC · Charleston, SCS/N 421C0293N513SJWagner Distributing Co Inc · Auburn, CABuilt 1975 · S/N 421C0043N514LPInvader Aviation LLC · Tijeras, NMBuilt 1980 · S/N 414A0507N514NCHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0514N517MHCbtm Aviation LLC · Leesburg, FLBuilt 1976 · S/N 421C0104N51QZAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1982 · S/N 421C1237N520ABGolden Eagle Transportation LLC · Lafayette, LABuilt 1979 · S/N 421C0690N521RMHeal Ray · Denton, TXBuilt 1977 · S/N 421C0335N524CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0522N525SFPrimrose LLC · Columbus, NEBuilt 1976 · S/N 421C0080N5288JOsborne Mobile Home Park LLC · North Little Rock, ARBuilt 1976 · S/N 421C0158N528TWEnviro Vat Lp · Midland, TXBuilt 1980 · S/N 421C1032N5293JWestsand Aviation LLC · Allegan, MIBuilt 1982 · S/N 414A0857N52RBHeights Multi Flight Management LLC · Monroeville, NJBuilt 1979 · S/N 414A0302N532EBJeb Air LLC · Waverly, OHBuilt 1980 · S/N 414A0440N532NMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 404-0624N533ACEast Tennessee Aviation Services LLC · Harrison, TNBuilt 1978 · S/N 414A0103N533STGentry Air LLC · Orlando, FLBuilt 1978 · S/N 414A0034N5355JRusty Simpson LLC · Nemo, TXS/N 421C0669N535CRScs Assets LLC · Ponce, PRBuilt 1979 · S/N 414A0244N5372CFlc Aviation LLC · Dyersburg, TNBuilt 1978 · S/N 414A0110N5388JRichland Aviation Inc · Sidney, MTBuilt 1980 · S/N 404-0666N53MG28 Lv LLC · Las Vegas, NVBuilt 1980 · S/N 421C0909N53MJAviation Hangar Foam Specialists LLC · Tucson, AZBuilt 1979 · S/N 421C0667N53WTRock House LLC · Keizer, ORBuilt 1980 · S/N 414A0533N5409GRichland Aviation Inc · Sidney, MTS/N 404-0028
Back to AD 95-09-13