Skip to content

Farkas Robert J

Earlier aircraft under this name · 182

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 = 'FARKAS ROBERT J' OR list_contains(d.other_registrant_names, 'FARKAS ROBERT J') 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 = 'FARKAS ROBERT J' OR list_contains(d.other_registrant_names, 'FARKAS ROBERT J')
  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 = 'FARKAS ROBERT J' OR list_contains(d.other_registrant_names, 'FARKAS ROBERT J')
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.

N47RYYaw Ralph G QUICKIE · S/N 436Cancelled Jun 26, 1989 · Administratively canceled · Yaw Ralph G, Bend, OR N944JWBoeing 707-321B · S/N 18336Cancelled May 29, 1986 · Administratively canceled · International Air Leases Inc, Miami, FL N17HUFuller Estan L CGS HAWK-A · S/N H1-17-CCancelled Sep 27, 1985 · Administratively canceled · Fuller Aviation Inc, Frankfort, IN N3225ZNoell-Oros ROTEC RALLY 3 · S/N 64646Cancelled Sep 27, 1985 · Administratively canceled · Noell Leonard R, Visalia, CA N5395RCessna 172F · S/N 17252932Cancelled Sep 20, 1985 · Administratively canceled · Bo-Air Inc, Gray Court, SC N104JKPiper PA-23-250 · S/N 27-7405471Cancelled Aug 8, 1985 · Administratively canceled · Spa Flying Service Inc, Hot Springs, AR N49013Cessna 152 · S/N 15281101Cancelled Aug 8, 1985 · Administratively canceled · Williams Susan M, Corona, CA N3972AWormley Thomas E WIZARD J3 · S/N J3-40-2865Cancelled Aug 1, 1985 · Administratively canceled · Wormley Thomas E, Orem, UT N1380DBerson Thomas R BE220 · S/N 1Cancelled Jul 25, 1985 · Administratively canceled · Berson Thomas R, Chugiak, AK N930AANethery Carl EAGLE 2-PLACE · S/N 400125Cancelled Mar 20, 1985 · Administratively canceled · Ultralight Of Ind Inc, Hebron, IN N44313Bellanca 17-31ATC · S/N 74-31100Cancelled Mar 4, 1985 · Administratively canceled · Dixie Flying Service Inc, Coral Gables, FL N1179CMiracle Robert D SONERAI II · S/N 135Cancelled Feb 20, 1985 · Administratively canceled · Miracle Robert D, Deforest, WI N98967Piper PA-12 · S/N 12-322Cancelled Feb 20, 1985 · Administratively canceled · Merritt Richard F, Alpena, MI N9900RBeech G18S · S/N BA-513Cancelled Feb 20, 1985 · Administratively canceled · Cannavo Frank Jr DBA, Lester, PA N9914KBell 206B · S/N 1933Cancelled Feb 20, 1985 · Administratively canceled · Petroleum Helicopters Inc, Lafayette, LA N2133LBell Helicopter Textron 206L-1 · S/N 45633Cancelled Feb 14, 1985 · Administratively canceled · Petroleum Helicopters Inc, Lafayette, LA N82195Piper PA-28RT-201T · S/N 28R-8031109Cancelled Feb 14, 1985 · Administratively canceled · Wes-Tex Aircraft Inc, Lubbock, TX N9923LGrumman American Avn. AA-1B · S/N AA1B-0223Cancelled Feb 14, 1985 · Administratively canceled · Tew Mac Aviation Inc, Tewksbury, MA N9964GCessna A188A · S/N 18800764Cancelled Feb 14, 1985 · Administratively canceled · Thedford Aero Inc, Greenville, MS N9973KBell 206L · S/N 45037Cancelled Feb 14, 1985 · Administratively canceled · Petroleum Helicopters Inc, Lafayette, LA N8439NPiper PA-34-220T · S/N 34-8133245Cancelled Feb 4, 1985 · Administratively canceled · Putnam Stephen, Novato, CA N38413Beech C23 · S/N M-2308Cancelled Jan 31, 1985 · Administratively canceled · Central Flying Service Inc, Little Rock, AR N42RHHight Roger G SMARAGD · S/N 007Cancelled Jan 31, 1985 · Administratively canceled · Hight Roger G, Hudson, OH N8981CPiper PA-28R-200 · S/N 28R-7635187Cancelled Jan 31, 1985 · Administratively canceled · Reiss Adolf E, Wichita, KS N99221Ercoupe 415-C · S/N 1844Cancelled Jan 22, 1985 · Administratively canceled · Heath Robert E, Morenci, AZ N99331Engineering & Research ERCOUPE 415-CD · S/N 1954Cancelled Jan 22, 1985 · Administratively canceled · Starrett James A, Hoboken, NJ N55779Don Piccard Balloons MULTI-BALLOON · S/N 1003Cancelled Jan 16, 1985 · Administratively canceled · Don Piccard Balloons Inc, Minneapolis, MN N1336PGeneral Devices HUMMER-B · S/N 0136BCancelled Jan 8, 1985 · Administratively canceled · Post-Air Division, Indianapolis, IN N414RECessna 414 · S/N 414-0262Cancelled Jan 8, 1985 · Administratively canceled · Eichhorn Robert E, D-8550 Forchheim N9096GCessna 182N · S/N 18260636Cancelled Jan 8, 1985 · Administratively canceled · Carr Donna M, Bettles, AK N15PTPiper Advanced Technology PAT-1 · S/N 1Cancelled Dec 11, 1984 · Administratively canceled · Piper Advanced Technology Inc, Wichita, KS N29LBAero Commander 1121 · S/N 61Cancelled Dec 11, 1984 · Administratively canceled · Mcwilliams W K Jr, Metairie, LA N94282Cessna 152 · S/N 15285637Cancelled Dec 11, 1984 · Administratively canceled · Tops Inc, Port Orchard, WA N4267XMcdonald Hal W STITS SA6B · S/N 658MCancelled Dec 6, 1984 · Administratively canceled · Mcdonald Hal W, Kearns, UT N9383ZCessna TU206G · S/N U20606449Cancelled Oct 31, 1984 · Exported to Ecuador · Missionary Aviation Fellowship, Redlands, CA N209DWWilson J Dale OSPREY-2 · S/N 05Cancelled Oct 26, 1984 · Administratively canceled · Wilson J Dale, Madison, WI N2623Bell Helicopter Textron 206L-1 · S/N 45641Cancelled Oct 26, 1984 · Administratively canceled · Mobil Oil Exploration And, New Orleans, LA N81RHHochgesang Robert A SONERAI-II · S/N 738Cancelled Oct 26, 1984 · Administratively canceled · Hochgesang Robert A, Medinah, IL N8492HHarwell Richard G F4U CORSAIR · S/N 22ACancelled Oct 26, 1984 · Administratively canceled · Harwell Richard G, Lynbrook, NY N8537PYoung Ansel E JUNIOR ACE D · S/N 1Cancelled Oct 26, 1984 · Administratively canceled · Young Ansel E, Tustin, CA N3841UBeech 77 · S/N WA-234Cancelled Oct 25, 1984 · Administratively canceled · Chaparral Aviation Inc, Dallas, TX N39572Piper PA-32RT-300T · S/N 32R-7887110Cancelled Oct 25, 1984 · Administratively canceled · M & K Leasing, Paramount, CA N219GBDouglas DC3 · S/N 50761Cancelled Oct 5, 1984 · Administratively canceled · Usda Forest Service, Washington, DC N2993PPeterson/Vierck ROTERWAY · S/N 2993Cancelled Oct 3, 1984 · Administratively canceled · Peterson Alan J, Ft Atkinson, WI N3882XSteffes Robert G ASCENDER II+2 · S/N 1264Cancelled Oct 3, 1984 · Administratively canceled · Steffesrobert G, Madison, WI N8514JFisher Michael E FISHER FLYER · S/N 101Cancelled Oct 3, 1984 · Administratively canceled · Fisher Michael E, South Webster, OH N352QTBell 206A · S/N 65Cancelled Sep 6, 1984 · Administratively canceled · Hollico Svcs Inc, Houton, TX N103DHDouglas DC-6A · S/N 43699Cancelled Aug 31, 1984 · Administratively canceled · Dhl Corp, San Bruno, CA N32275Martin Douglas CH B-8M · S/N 001Cancelled Aug 31, 1984 · Administratively canceled · Martin Douglas C H, Lindale, GA N8537ZLampl James B HUMMER-A · S/N 0049ACancelled Aug 31, 1984 · Administratively canceled · Lampl James B, Allison Park, PA

Back to Farkas Robert J