Skip to content

Earlier aircraft under this name · 495

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 = 'FREY CHARLES' OR list_contains(d.other_registrant_names, 'FREY CHARLES') 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 = 'FREY CHARLES' OR list_contains(d.other_registrant_names, 'FREY CHARLES')
  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 = 'FREY CHARLES' OR list_contains(d.other_registrant_names, 'FREY CHARLES')
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.

N8227CPiper PA-28-140 · S/N 28-7625089Cancelled Oct 25, 1984 · Administratively canceled · Bolling Bill J, Hopkinsville, KY N1363Smith MINIPLANE · S/N L.N.2Cancelled Oct 5, 1984 · Administratively canceled · Girod Pete, Monroe, IN N13876Newman Waldo L B-8M · S/N WLN-1Cancelled Oct 5, 1984 · Administratively canceled · Newman Waldo L, Indianapolis, IN N3024Beech UC-45J · S/N 67234Cancelled Oct 5, 1984 · Administratively canceled · Rock Valley College, Rockford, IL N34370Cessna 177B · S/N 17701782Cancelled Oct 5, 1984 · Administratively canceled · Lindenberg Martin, Spring Valley, NY N3713JCessna 150G · S/N 15065013Cancelled Oct 5, 1984 · Administratively canceled · Obrien James P, Stormville, NY N9056UGlover Ray M MUSTANG II · S/N M-II289Cancelled Oct 5, 1984 · Administratively canceled · Glover Ray M, Spencer, OK N2702VCessna 177RG · S/N 177RG0662Cancelled Oct 3, 1984 · Administratively canceled · Elliott Arthur Robert, Dallas, TX N29033Piper PA-28RT-201T · S/N 28R-7931190Cancelled Oct 3, 1984 · Administratively canceled · Mountain Associates, Englewood, CO N29391Cessna 172M · S/N 17264116Cancelled Oct 3, 1984 · Administratively canceled · Bellomo Leasing Corp, Plainview, NY N3062JCessna 150E · S/N 15061162Cancelled Oct 3, 1984 · Administratively canceled · Wesley Martin R, Knob Noster, MO N32750Piper PA-32-260 · S/N 32-7500008Cancelled Oct 3, 1984 · Administratively canceled · Basco Flying Service Inc, Pottstown, PA N35206Piper PA-31-350 · S/N 31-7952193Cancelled Oct 3, 1984 · Administratively canceled · Southcentral Air Inc, Kenai, AK 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 N8229KUniversal Stinson 108-1 · S/N 1229Cancelled Oct 1, 1984 · Administratively canceled · Lvh Aircraft Inc, Maple Lake, MN N93SMWittman Tailwind W-8 · S/N 21Cancelled Sep 18, 1984 · Administratively canceled · Mockrud Stanley C, Madison, WI N3572WPiper PA-32-260 · S/N 32-464Cancelled Sep 6, 1984 · Administratively canceled · Antilles American Seafood Corp, St Maarteen N93801Engineering & Research ERCOUPE 415-C · S/N 1124Cancelled Sep 6, 1984 · Administratively canceled · Widener John H, Hooker, OK N831PCPiper PA-31T · S/N 31T-8020001Cancelled Sep 5, 1984 · Administratively canceled · Beach Airways, West Palm Beach, FL N28255Williams RALLY 3 · S/N 64602Cancelled Aug 31, 1984 · Administratively canceled · Pavalonis Richard L, Alta Loma, TX N9514WPiper PA-28-140 · S/N 28-22939Cancelled Aug 31, 1984 · Administratively canceled · Lewis Bruce E, Limerick, ME N8300GCessna 150F · S/N 15062400Cancelled Aug 29, 1984 · Administratively canceled · Sheridan Mites S, Sedona, AZ N8738Boeing 707-331B · S/N 20067Cancelled Aug 22, 1984 · Administratively canceled · Irving Trust Co Trustee, New York, NY N3043LCessna 310J · S/N 310J0043Cancelled Aug 20, 1984 · Administratively canceled · Sanchez Manuel, St Maarten N8227MCessna T210K · S/N 21059227Cancelled Aug 20, 1984 · Administratively canceled · Cardinal Flight Service, Burlington, VT N8232GCessna 177RG · S/N 177RG0132Cancelled Aug 20, 1984 · Administratively canceled · Barclay Ralph R, Nevada City, CA N86EVCessna 414 · S/N 414-0488Cancelled Aug 20, 1984 · Administratively canceled · Crest Air Inc, Pineville, LA 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 N37USPiccard AX-6 · S/N 637Cancelled Aug 15, 1984 · Administratively canceled · Pruett Lee T, Austin, TX N8031HHarris Lawrence BENSEN GYROCOPTER · S/N H-1943-79Cancelled Aug 14, 1984 · Administratively canceled · Harris Lawrence, Rock Hill, MO N8247HCallair A-9A · S/N 1120Cancelled Aug 14, 1984 · Administratively canceled · Pevey Ronald B, Springfield, GA N8524PHuckfeldt Carl A. O. KR-2 · S/N CL5-1Cancelled Aug 14, 1984 · Administratively canceled · Huckfeldt Carl A O, Littleton, CO N35TABell 206B · S/N 1479Cancelled Aug 11, 1984 · Administratively canceled · Air Metro Helicopters Inc, New City, NY N8706WPiper PA-28-235 · S/N 28-10239Cancelled Aug 11, 1984 · Administratively canceled · Urban Norman A, Warren, MI N34627Cessna 177B · S/N 17701908Cancelled Aug 6, 1984 · Administratively canceled · Storey Paul E, Woodstock, GA N8735Boeing 707-331B · S/N 20064Cancelled Aug 6, 1984 · Administratively canceled · Aviation Sales Company Inc, Miami, FL N3458SCessna 182H · S/N 18255858Cancelled Aug 2, 1984 · Administratively canceled · Klabunde Harold, Emmet, ND N8496MCessna A150K · S/N A15000196Cancelled Aug 2, 1984 · Administratively canceled · Aviation Explorer Post Inc, San Diego, CA N32BPPulver BREEZY RLU-1 · S/N 30R4Cancelled Aug 1, 1984 · Administratively canceled · Pulver Robert E, Otsego, MI N80059Aerotek PITTS S-2A · S/N 2139Cancelled Aug 1, 1984 · Administratively canceled · Norton Aero Ltd, Athol, ID N86869Bellanca 14-13 · S/N 1231Cancelled Aug 1, 1984 · Administratively canceled · Weir Lyon S, Los Angeles, CA N2741JCessna A150M · S/N A1500579Cancelled Jul 24, 1984 · Administratively canceled · Roosevelt Roads Navy Flying Club, Ceiba, PR N32561Smith Michael D ULTRALITE J3-2 · S/N 0002Cancelled Jul 21, 1984 · Administratively canceled · Smith Michael D, Huntington Beach, CA N33658Bowlus BSA-100 · S/N 102Cancelled Jul 21, 1984 · Administratively canceled · Stiglmeier Herman J, Kila Kauarl, HI N3893TPiper PA-28R-180 · S/N 28R-30222Cancelled Jul 21, 1984 · Administratively canceled · Tri Service Enterprises Inc, Clinton, MD 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

Back to Frey Charles