Skip to content

Cancelled registrations · 202

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_state = 'OR' AND d.registrant_city = 'BEND' 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_state = 'OR' AND d.registrant_city = 'BEND'
  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_state = 'OR' AND d.registrant_city = 'BEND'
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.

N62345Let BLANIK L-13 · S/N 027012Cancelled Dec 6, 2012 · First renewal notice · Built 1977 · High Desert Soaring Club Inc N87686Hartmann BRIEGLEB BG-12A · S/N 1Cancelled Nov 26, 2012 · Sale reported, pending cancellation · Built 1963 N222BLCessna 421B · S/N 421B0824Cancelled Oct 16, 2012 · Registration expired, pending cancellation · Built 1974 · Aviation Investments Inc N6322QMooney M20F · S/N 670415Cancelled Oct 10, 2012 · Exported to Canada · Built 1967 · Simmons Boyd W N8XKWjjs EPIC LT · S/N 007Cancelled Oct 4, 2012 · Registration expired, pending cancellation · Wjjs LLC N540RAAmerican Eurocopter AS350B2 · S/N 7363Cancelled Oct 3, 2012 · Exported to Brazil · Built 2012 · Rotor Aviation N869CCSmith AEROSTAR 601P · S/N 61P-0235-035Cancelled Sep 12, 2012 · Registration pending, canceled · Built 1975 N332LRNelson SCORPION 133 · S/N 1001Cancelled Sep 11, 2012 · Sale reported, canceled · Built 1978 N4733SAB Flygindustri JS WEIHE · S/N 228Cancelled Aug 6, 2012 · Revoked, canceled · Built 1963 · Morgan Walter N666GKBeech D-50 · S/N DH-94Cancelled Aug 6, 2012 · Registration pending, canceled · Built 1956 N520RAEurocopter EC 130 B4 · S/N 7358Cancelled Jul 24, 2012 · Exported to Brazil · Rotor Aviation Inc N1453APiper PA-22-135 · S/N 22-555Cancelled Jun 21, 2012 · Sale reported, canceled · Built 1952 N381AEEurocopter EC 130 B4 · S/N 7308Cancelled Jun 20, 2012 · Exported to Brazil · Rotor Aviation Inc N22CTCessna T210M · S/N 21061708Cancelled May 30, 2012 · Second renewal notice · Built 1977 · Worthington Jack C N44882Robinson Helicopter R66 · S/N 0030Cancelled Mar 28, 2012 · Exported to Brazil · Built 2011 · Rotor Aviation N707LVEurocopter EC 130 B4 · S/N 4388Cancelled Mar 26, 2012 · Exported to Brazil · Rotor Aviation Inc N207AEAmerican Eurocopter AS350B2 · S/N 7243Cancelled Feb 17, 2012 · Exported to Brazil · Built 2011 · Rotor Aviation Inc N375AAAero Commander 690A · S/N 11179Cancelled Feb 13, 2012 · Exported to Mexico · Built 1974 · Liska Miroslav N987AEAmerican Eurocopter AS350B2 · S/N 7195Cancelled Dec 23, 2011 · Exported to Brazil · Built 2011 · Rotor Aviation Inc N132VVance Wesley LANCAIR 235 · S/N 132Cancelled Sep 30, 2011 · Exported to Chile · Built 2000 · Simmons Boyd W N556WWahl SPEZIO SPORT DAL-1 · S/N 261Cancelled Sep 7, 2011 · Second renewal notice · Built 1970 · Johnson Lester B N56802Schweizer SGS 2-8 · S/N 29Cancelled Aug 31, 2011 · Revoked, pending cancellation · Built 1945 · Morgan Walter N2370RRaven S-60A · S/N S60A-129Cancelled Aug 19, 2011 · Sale reported, pending cancellation · Built 1978 N5VCAmerican Eurocopter AS350B2 · S/N 4737Cancelled Apr 29, 2011 · Exported to Brazil · Built 2009 · Rotor Aviation Inc N515TDEurocopter EC 130 B4 · S/N 3863Cancelled Apr 15, 2011 · Exported to Brazil · Built 2004 · Rotor Aviation Inc N106JHWindward Performance SPARROW HAWK · S/N 22Cancelled Nov 22, 2010 · Exported to Australia N784AEAmerican Eurocopter AS350B2 · S/N 4769Cancelled Oct 15, 2010 · Exported to Brazil · Built 2010 · Rotor Aviation Inc N590KCessna T206H · S/N T20608519Cancelled Oct 5, 2010 · Exported to Canada · Built 2005 · Cimarron Aviation Inc N6930NCessna T210N · S/N 21063160Cancelled Oct 1, 2010 · Exported to Australia · Built 1978 · Horrell Tim K N759KLCessna 182Q · S/N 18266054Cancelled May 19, 2010 · Exported to Canada · Built 1977 · Oconnor Christopher M N489RARobinson Helicopter R44 II · S/N 12022Cancelled Feb 26, 2010 · Exported to Brazil · Built 2007 · Rotor Aviation Inc N3547ACessna 172S · S/N 172S8931Cancelled Feb 23, 2010 · Exported to Guatemala · Built 2001 · Spirit Flight Inc DBA N21XWSchleicher ASW-15B · S/N 15186Cancelled Oct 28, 2009 · Triennial form not returned · Built 1972 · Page Wayne A N99JPBeech 35-B33 · S/N CD-773Cancelled Sep 28, 2009 · Exported to Canada · Built 1964 · Marquis Holdings Ltd N12021Maule M-4 · S/N 32Cancelled Jul 2, 2009 · Registration revoked · Built 1963 · Chausse David N46VBRobinson Helicopter R44 II · S/N 11958Cancelled Jun 18, 2009 · Exported to Brazil · Rotor Aviation N2468YMooney M20M · S/N 27-0242Cancelled Aug 5, 2008 · Exported to Canada · Built 1998 · Mooney Management LLC N7527CRobinson Helicopter R44 II · S/N 11141Cancelled Jun 4, 2008 · Exported to Brazil · Built 2006 · Rotor Aviation Inc N555TEEllsberg Tom ONE DESIGN · S/N 94-0239Cancelled Nov 27, 2007 · Triennial form not returned · Built 1996 · Ellsberg Thomas R N1121UColumbia Aircraft Mfg LC41-550FG · S/N 41783Cancelled Sep 24, 2007 · Exported to Mexico · Columbia Aircraft Manufacturing Corp N3144DBeech B36TC · S/N EA-472Cancelled Aug 20, 2007 · Built 1987 · St Elmos Aviation Leasing LLC N128LNeiubauer Lance A HELISPORT CH 7 KOMPR · S/N 056Cancelled Jun 22, 2007 · Triennial form not returned · Built 2001 · Neibauer Lance A N392JADiamond Aircraft Ind DA20-C1 · S/N C0206Cancelled Jun 20, 2007 · Exported to Germany · Built 2003 · Bend Air LLC N398JADiamond Aircraft Ind DA20-C1 · S/N C0214Cancelled Jun 20, 2007 · Exported to Germany · Built 2003 · Bend Air LLC N974ZCessna T182T · S/N T18208270Cancelled Oct 5, 2006 · Exported to Canada · Built 2004 · Jec Enterprises Inc N162RPOsterhuber Richard P ROTORWAY EXEC 162F · S/N 6712Cancelled Sep 7, 2006 · Built 2005 · Osterhuber Richard P N701TLLevy John ZENAIR CH701SP · S/N 7-9708Cancelled Jan 5, 2006 · Exported to New Zealand · Built 2005 · Levy John N74558Robinson Helicopter R22 BETA · S/N 3901Cancelled Jan 5, 2006 · Exported to New Zealand · Built 2005 · Levy John C Jr N3665XAero Commander S2R · S/N 1892RCancelled Oct 26, 2005 · Sale reported · Built 1974 N166PDLancair LC41-550FG · S/N 41001Cancelled Aug 22, 2005 · Built 2002 · Lancair Company

Back to Bend, OR