AD 2005-12-13

Registered aircraft · 479

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:2005-12-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:2005-12-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.

N7037EHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0471N706CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0095N717BDWeathered Aviation Inc · Rogers, ARBuilt 1979 · S/N 414A0337N72JAOtter Air LLC · Fishers, INBuilt 1979 · S/N 414A0333N72KGM & P Aviation LLC · Byhalia, MSBuilt 1980 · S/N 414A0513N73TBMagic Leasing LLC · Peotone, ILBuilt 1981 · S/N 414A0474N740CAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0277N744BWDobson'S Leasing Co LLC · Ocoee, FLBuilt 1981 · S/N 414A0658N747WSHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0080N74PBBaranko Peter A · Meridian, IDBuilt 1981 · S/N 414A0828N751CAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0217N754KCPlane Crazy Aviation LLC · Fargo, NDBuilt 1981 · S/N 414A0803N75TTReisback Scott · Olalla, WAS/N 414A0405N763EAHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0497N764EAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0237N764PBBisono Pablo R · Guaynabo, PRS/N 402C0338N769EAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0303N771EAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0046N775RCAirswiss Inc · Wilmington, DEBuilt 1980 · S/N 402C0311N787DRBad Aire LLC · Aledo, TXS/N 414A0503N789PTValiair Limited Company · Casper, WYBuilt 1985 · S/N 414A1209N78DGUsac N78dg LLC · Wall Township, NJBuilt 1981 · S/N 414A-0641N78KC5634 Aviation LLC · Flowery Branch, GABuilt 1978 · S/N 414A-0045N78NGRam Aero Development Inc · Waco, TXS/N 414A0617N794PCFlioway LLC · Iowa City, IABuilt 1978 · S/N 414A0098N797RACool Air Travel LLC · Macon, GABuilt 1978 · S/N 414A0119N799ESFive Boys Flight Training LLC · Matthews, NCBuilt 1981 · S/N 414A0657N79BPOrion 207 LLC · Harpswell, MEBuilt 1979 · S/N 414A0263N79DCBnb Marine LLC · Miami, FLS/N 414A0212N79FWDaniel King Aviation LLC · Dover, DEBuilt 1979 · S/N 414A0278N79PPJon Gibson Co · Cameron Park, CABuilt 1980 · S/N 414A0516N800BAN8vv Inc · Corpus Christi, TXBuilt 1981 · S/N 414A0667N802HLAir Hammer LLC · Wilmington, DES/N 414A0820N805PRValiair Lc Trustee · Casper, WYBuilt 1985 · S/N 414A1206N80JJZing Aviation And Marine LLC · New Smyrna, FLFirst renewal noticeS/N 414A0412N810BWHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0279N812SRVantage Point Northwest Aviation LLC · Sheridan, WYBuilt 1979 · S/N 414A0326N818ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 402C0501N824RBShark Water Systems LLC · Hobbs, NMBuilt 1979 · S/N 414A0411N82AWQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 414A0064N82DAAircraft Holding Solutions LLC Trustee · Newark, DES/N 414A0476N82GLJusticia Holdings LLC · Roanoke, VAS/N 414A0275N831BMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1979 · S/N 414A0340N83DLake Placid Flying Service Inc · Lake Placid, NYBuilt 1981 · S/N 414A-0615N83PBHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0350N84DAVoorhees Investments Inc · Costa Mesa, CABuilt 1980 · S/N 414A0519N84PRSkov Equipment Co · Fabens, TXBuilt 1979 · S/N 414A0213N855HSanford Larry D · Edmond, OKBuilt 1982 · S/N 414A0855N86AWMohave County Sheriff'S Office · Kingman, AZBuilt 1978 · S/N 414A0040N86PDTanric Aviation LLC · Tuscola, TXBuilt 1982 · S/N 414A0837
Back to AD 2005-12-13