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.

N43MRFlight Contract Services Inc · Las Vegas, NVS/N 414A-0016N440DL421 Partners LLC · Crown Point, INBuilt 1983 · S/N 421C1401N440LJByington William · Minden, NVS/N 421C0299N441TPUnited Contractors Inc · Costa Mesa, CABuilt 1978 · S/N 414A0057N441TTSunbird Airlines Inc · San Juan, PRBuilt 1981 · S/N 402C0441N442CCRaymond Andrew A · Crescent, IAS/N 414A0483N442FMHogan Quinn H Trustee · Milwaukee, WIBuilt 1979 · S/N 414A0303N444BGMitchell Aviation LLC · Mitchell, SDBuilt 1980 · S/N 421C0893N444HDChado Richard P II · Rancho Cucamonga, CAS/N 421C0480N4492UAircraft & Aviation Professionals LLC · Coldwater, MIS/N 421C0020N44GAFly Qts LLC · Oconomowoc, WIBuilt 1978 · S/N 414A0036N451AMPalm Tree Adventures LLC · Austin, TXS/N 421C0808N454SPSps Investment Properties LLC · Macon, GABuilt 1980 · S/N 414A0626N459DMStafford Wings LLC · Fredericksburg, VABuilt 1981 · S/N 421C1084N45BBSpeer Aircraft LLC · Evansville, INBuilt 1979 · S/N 421C0661N45JRJmf Inc · St Maries, IDBuilt 1976 · S/N 421C0109N4630NHyannis Air Service Inc · Hyannis, MABuilt 1978 · S/N 402C0001N464DCDelta Charlie Aviation LLC · Glendale, AZBuilt 1979 · S/N 421C0709N4666NM & P Genpar LLC · Corpus Christi, TXBuilt 1978 · S/N 414A0059N4668NSre Holdings LLC · Dewitt, MIFirst renewal noticeBuilt 1978 · S/N 414A0061N466CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0428N466JWWf Construction Inc · La Verne, CAS/N 421C0241N4677NLps Equipment And Acquisition Co Inc · Clarksburg, TNBuilt 1978 · S/N 414A0068N4680NRentz Communications Inc · New Smyrna Beach, FLBuilt 1978 · S/N 414A0070N4693NWade Air LLC · West Palm Beach, FLS/N 414A0079N4698AExpress Air LLC · Wilmington, DES/N 414A0083N469CJHerndon Aviation LLC · Kokomo, INBuilt 1980 · S/N 421C1018N4701AWtfa LLC · Decatur, ALBuilt 1978 · S/N 414A0085N471BWPatriot Environmental LLC · Meeker, OKS/N 421C0640N471MASwift Aviation LLC · Decatur, TNBuilt 1979 · S/N 414A0279N4725CContinental Aerospace Technologies Inc · Mobile, ALBuilt 1982 · S/N T30300118N475RCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1978 · S/N 4040223N4772ADodson International Parts Inc · Rantoul, KSS/N 414A0095N477RSSundbird Airlines Inc · San Juan, PRBuilt 1981 · S/N 402C0477N47JDQualitair LLC Trustee · MichelstadtBuilt 1980 · S/N 421C0805N47KKHermansen Dane K · Ormond Beach, FLBuilt 1983 · S/N T30300216N4837ALongleaf Wing Ventures LLC · Birmingham, ALBuilt 1978 · S/N 414A0101N483MMWestern Rivers Aircraft LLC · Paducah, KYBuilt 1977 · S/N 421C0314N484SWElsass Aviation LLC · Fayetteville, ARBuilt 1980 · S/N 414A0497N485CBBlue Pathways LLC · Statesville, NCS/N 421C0466N485DSEncinal Aviation LLC · Springfield, MOBuilt 1978 · S/N 421C0459N488DMAircraft One Ltd · Grand Rapids, MIS/N 421C-0485N488KRedcell Air Inc · Miami, FLBuilt 1976 · S/N 421C0078N48AMGwc Air LLC · Madison, ALBuilt 1980 · S/N 414A0609N48CPDouglas Aviation Ltd · South Barrington, ILS/N 421C0902N48SAUltra Aviation Management Inc · Miami, FLBuilt 1979 · S/N 404-0417N493JHBrooklyn LLC · Parker, COS/N 421C0860N4949CHatchie River Aviation LLC · Kalispell, MTBuilt 1982 · S/N T30300128N494BCHyannis Air Service Inc · Hyannis, MAS/N 402C0308N494TSDeep Creek Lake Ventures LLC · Oakland, MDBuilt 1983 · S/N T30300201
Back to AD 95-09-13