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.

N58ZPCk Investor Inc · Lubbock, TXS/N 421C0705N596DMAirswiss Inc · Wilmington, DES/N 402C0255N598ASAssociated Auction & Liquidation Co · Clarksburg, TNBuilt 1984 · S/N 414A1003N598DMAirswiss Inc · Wilmington, DEBuilt 1979 · S/N 402C0114N5AMTexas La Flyers LLC · West Monroe, LAFirst renewal noticeBuilt 1979 · S/N 414A0441N5CNLewis Gentry Holdings LLC · Orlando, FLBuilt 1978 · S/N 414A0073N5ERMill Direct Textiles LLC · Rollinsford, NHBuilt 1982 · S/N T30300137N5NMNelson Jeffrey S · Darby, MTBuilt 1978 · S/N 414A0042N5NNRkgrier LLC · Beckley, WVS/N 421C0446N5UTK&L Salty Air LLC · Stephenville, TXBuilt 1976 · S/N 421C0101N600DCHerron Aviation Group LLC · Dexter, MIS/N 421C1007N600HCCessna 414a LLC · Portland, ORBuilt 1978 · S/N 414A0025N600THN600th LLC · Fredericksburg, VABuilt 1981 · S/N 414A0668N602DCKeystone Xpress LLC · Rostraver Twp, PAS/N 421C0864N605DCT&C Aviators LLC · Green Cove Springs, FLS/N 421C-1005N605SRPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N 421C1041N607JDJd 707 Air LLC · Edgerton, OHBuilt 1978 · S/N 414A0071N608RCRichland Aviation Inc · Sidney, MTS/N 404-0608N609DSTj Air Holdings Inc · Wilmington, DEBuilt 1981 · S/N T30300025N60GMInternational Air Services Inc Trustee · Carson City, NVS/N 421C-0828N6115CHat Investments LLC · Spartanburg, SCS/N 421C0890N6161XGolden Eagle Aircraft LLC · Boulder, COS/N 421C0895N6161ZSkybound Holdings LLC · Orlando, FLBuilt 1978 · S/N 414A0019N616STK&S Flights LLC · Sweet Valley, PABuilt 1981 · S/N 414A0806N617CCRiley Livestock Inc · Mayfield, KYS/N 421C0897N618CAHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0620N619ACFeed Yard Industrial Solutions LLC · Amarillo, TXBuilt 1977 · S/N 421C0336N61AJCoco Air Ltd Trustee · Wilmington, DEBuilt 1978 · S/N 421C0457N61JV61jv LLC · Chuckey, TNS/N 421C0097N622TRL C A Inc · Alamo, CABuilt 1980 · S/N 421C0858N625JLTurbulent Returns LLC · Minneapolis, MNBuilt 1980 · S/N 414A0508N626DRK And L Transportation LLC · Carterville, ILFirst renewal noticeS/N 421C0512N628JWJuliet Whiskey LLC · Roanoke, VABuilt 1979 · S/N 414A0241N629WMVortech LLC · Woodbury, NYS/N 421C1001N62JCChuoke Joseph P · Texas City, TXS/N 421C0498N630ADT Machine LLC · Livingston, MTBuilt 1977 · S/N 421C0406N6315XEagle Aviation LLC · Morristown, TNBuilt 1981 · S/N 421C1003N633MCSveen Jeffrey T · Aberdeen, SDBuilt 1979 · S/N 421C0657N635MAAirswiss Inc · Wilmington, DES/N 402C0634N63DBDelta Properties Llp · Nogales, AZS/N 414A1211N643WMBarham Investments LLC · Dexter, MOBuilt 1985 · S/N 414A1205N6486VVroom Engineering Inc · Tucson, AZBuilt 1984 · S/N T30300311N648SBHays Kelly · Dumas, TXBuilt 1979 · S/N 421C0648N6498VSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1984 · S/N T30300313N650BDV1vr LLC · Saint Louis, MOBuilt 1979 · S/N 414A0404N650DBValiair Limited Company Trustee · Casper, WYBuilt 1982 · S/N 414A0853N650RMAcci Aviation LLC · Conway, ARBuilt 1978 · S/N 414A0031N6561CTrtc Aviation LLC · Byron Center, MIBuilt 1977 · S/N 414A0014N6578CPapoose Air II LLC · Wilmington, DEBuilt 1978 · S/N 414A0020N657WMRegistration Pending · Carlsbad, NMRegistration pendingS/N 421C0474
Back to AD 95-09-13