Skip to content

Earlier aircraft under this name · 205

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'PHARE WESTON D' OR list_contains(d.other_registrant_names, 'PHARE WESTON D') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_name = 'PHARE WESTON D' OR list_contains(d.other_registrant_names, 'PHARE WESTON D')
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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.

SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
WHERE d.registrant_name = 'PHARE WESTON D' OR list_contains(d.other_registrant_names, 'PHARE WESTON D')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N9271Enstrom F-28A · S/N 246Cancelled Sep 17, 1990 · Administratively canceled · Fluet Romeo E, Hollis, NH N8759DPiper PA-22-160 · S/N 22-5943Cancelled Sep 16, 1985 · Administratively canceled · Chitiea Andrew D, Aurora, CO N89757Cessna 152 · S/N 15282855Cancelled Mar 20, 1985 · Administratively canceled · Boardman Flight Academy Inc, Fort Worth, TX N9196ACessna 170A · S/N 18957Cancelled Feb 14, 1985 · Administratively canceled · Mcleod Albert D, Moss Point, MS N9513DPiper PA-22-160 · S/N 22-6429Cancelled Feb 14, 1985 · Administratively canceled · Smith Howard C, Spring, TX N8917VCessna 172M · S/N 17264274Cancelled Jan 31, 1985 · Administratively canceled · Civil Air Patrol Inc, Maxwell Afb, AL N9002QBeech V35B · S/N D-9166Cancelled Jan 31, 1985 · Administratively canceled · Swoboda Robert H, Cairo, IL N9050DPiper PA-22-160 · S/N 22-6189Cancelled Jan 31, 1985 · Administratively canceled · Faber Harold E, Bonners Ferry, ID N9094PPiper PA-24-260 · S/N 24-4569Cancelled Jan 31, 1985 · Administratively canceled · Phoenix Flyers Inc, Phoenix, AZ N8637ZCessna P206C · S/N P206-0437Cancelled Jan 22, 1985 · Administratively canceled · Parker Richard, Andrews, NC N86804Bellanca 14-13-2 · S/N 1165Cancelled Jan 22, 1985 · Administratively canceled · Tocher Arlen C, Carmichael, CA N8732EPiper PA-28-151 · S/N 28-7615155Cancelled Jan 22, 1985 · Administratively canceled · Turner Jay O, Woodside, CA N8807TCessna 182C · S/N 52707Cancelled Jan 22, 1985 · Administratively canceled · St Maries Cap Aero Club Inc, St Maries, ID N9164YPiper PA-31-310 · S/N 31-217Cancelled Jan 22, 1985 · Administratively canceled · Turbo Sales And Leasing, Bowling Green, KY N9303JPiper PA-28-180 · S/N 28-3394Cancelled Jan 22, 1985 · Administratively canceled · Iosco Flying Club Inc, East Tawas, MI N93338Cessna T210L · S/N 21060367Cancelled Jan 22, 1985 · Administratively canceled · Dobbs William, Foster City, CA N9274FHughes 369HS · S/N 160781SCancelled Dec 11, 1984 · Administratively canceled · US Department Of Justice, Washington, DC N8969ZCessna 310G · S/N 310G0069Cancelled Oct 26, 1984 · Administratively canceled · Chrisair Management Services Inc, Ny, NY N923CStinson 108-3 · S/N 108-3923Cancelled Oct 26, 1984 · Administratively canceled · Bourgeois Richard J, Thibodaux, LA N9361XCessna 182E · S/N 18253761Cancelled Oct 26, 1984 · Administratively canceled · Academy Flyers Inc, Phoenix, AZ N9056UGlover Ray M MUSTANG II · S/N M-II289Cancelled Oct 5, 1984 · Administratively canceled · Glover Ray M, Spencer, OK N8908PPiper PA-24-260 · S/N 24-4363Cancelled Oct 3, 1984 · Administratively canceled · Emr Aviation, Redmond, WA N9083HCessna 172M · S/N 17265931Cancelled Oct 3, 1984 · Administratively canceled · Lake Tahoe Aviation Inc, South Lake Tahoe, CA N931DBAerospatiale SA341G GAZELLE · S/N 1207Cancelled Oct 3, 1984 · Administratively canceled · Aerospatiale Helicopter Corporation, Grand Prairie, TX N93SMWittman Tailwind W-8 · S/N 21Cancelled Sep 18, 1984 · Administratively canceled · Mockrud Stanley C, Madison, WI N93801Engineering & Research ERCOUPE 415-C · S/N 1124Cancelled Sep 6, 1984 · Administratively canceled · Widener John H, Hooker, OK N9514WPiper PA-28-140 · S/N 28-22939Cancelled Aug 31, 1984 · Administratively canceled · Lewis Bruce E, Limerick, ME N8738Boeing 707-331B · S/N 20067Cancelled Aug 22, 1984 · Administratively canceled · Irving Trust Co Trustee, New York, NY N90286Robinson Helicopter R22 · S/N 0051Cancelled Aug 20, 1984 · Administratively canceled · Kenn Air Corporation, Westlake, OH N9410BCessna 175 · S/N 55210Cancelled Aug 20, 1984 · Administratively canceled · Bos Bernard D, Helena, MT N8706WPiper PA-28-235 · S/N 28-10239Cancelled Aug 11, 1984 · Administratively canceled · Urban Norman A, Warren, MI N8735Boeing 707-331B · S/N 20064Cancelled Aug 6, 1984 · Administratively canceled · Aviation Sales Company Inc, Miami, FL N86869Bellanca 14-13 · S/N 1231Cancelled Aug 1, 1984 · Administratively canceled · Weir Lyon S, Los Angeles, CA N9274KStinson 108-2 · S/N 108-2274Cancelled Jul 21, 1984 · Administratively canceled · Lee Thomas G, Anchorage, AK N9515Glasflugel H 301 LIBELLE · S/N 90Cancelled Jul 21, 1984 · Administratively canceled · Frauens Frederick W, San Anselmo, CA N90534Gardner J L STEEN SKYBOLT-A · S/N 7-13-19Cancelled Jul 18, 1984 · Administratively canceled · Gardner Junior L, Milton, FL N8646Bellanca 7ECA · S/N 919-73Cancelled Jul 11, 1984 · Administratively canceled · Stout Glenn L, Iowa Park, TX N8801FHughes 269A · S/N 112-0135Cancelled Jul 11, 1984 · Administratively canceled · Johnston John H, Wetumpka, AL N90977Bellanca 7ECA · S/N 903-73Cancelled Jul 11, 1984 · Administratively canceled · Vaughan Michael R, Kansas, IL N9125GCessna A188B · S/N 18801386TCancelled Jul 11, 1984 · Administratively canceled · Lewis Roger E, Sterlington, LA N9388KStinson 108-2 · S/N 108-2388Cancelled Jul 11, 1984 · Administratively canceled · Wall O Ray, Huntsville, AL N9031FRobinson Helicopter R22 · S/N 0077Cancelled Jul 6, 1984 · Administratively canceled · Roto Flite Inc, Wabash, IN N8952LGrumman American Avn. AA-1B · S/N AA1B-0402Cancelled Jul 3, 1984 · Administratively canceled · Moore Teddy L, Columbus, OH N8979LGrumman American Avn. AA-1B · S/N AA1B-0429Cancelled Jul 3, 1984 · Administratively canceled · Hanusa Robert L, Wailuku Maui, HI N89948Cessna 152 · S/N 15282924Cancelled Jul 3, 1984 · Administratively canceled · Rozhon & Schiejok Inc DBA, Hollywood, FL N9490ASmith Terry B. SCORPION 133 · S/N S1125-78Cancelled Jun 22, 1984 · Administratively canceled · Millhorn Farms Inc, Worley, ID N90015Bell 206B · S/N 1528Cancelled Jun 15, 1984 · Administratively canceled · Triple S Drilling Co Inc, Liberty, KY N87643Douglas C-47A · S/N 13060Cancelled Jun 2, 1984 · Administratively canceled · Acme Aircraft Company, Tucson, AZ N87666Douglas C-47D · S/N 32589Cancelled Jun 2, 1984 · Administratively canceled · Acme Aircraft Company, Tucson, AZ N90982Bellanca 7ECA · S/N 906-73Cancelled Jun 2, 1984 · Administratively canceled · Mckinley William Isaac, Pearsall, TX

Back to Phare Weston D