Skip to content

Cancelled registrations · 389

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 = 'WI' AND d.registrant_city = 'MILWAUKEE' 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 = 'WI' AND d.registrant_city = 'MILWAUKEE'
  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 = 'WI' AND d.registrant_city = 'MILWAUKEE'
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.

N31894Aeronca 65-LB · S/N L11731Cancelled Oct 28, 2017 · Revoked, canceled · Built 1941 · Emshoff Frank C N25501Briegleb BG-6 · S/N 34Cancelled Oct 25, 2017 · Registration expired, pending cancellation · Winnebago Soaring Association N5785ZPiper PA-22-108 · S/N 22-9629Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1963 · Riding Stephen H N643ABSchuttke Ronald J RAF 2000 GTX · S/N H2-05-16-654Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Schuttke Ronald J N4504BCessna 402B · S/N 402B1370Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1978 · Freight Runners Express Inc N727CACessna 402A · S/N 402A0102Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1969 · Freight Runners Express Inc N90551Beech D18S · S/N A-421Cancelled Feb 4, 2017 · Revoked, canceled · Built 1956 · Marinebanc Leasing Company Inc N41MAAnderson AQUILA 1 · S/N BAJ004Cancelled May 7, 2015 · Registration expired, pending cancellation · Built 1974 · Goodman Daniel G N83794Stelter B-8M · S/N S-1Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1977 · Mink Richard T N50327Cessna 150H · S/N 15069230Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1968 · Mahas Fine Food Inc N2596NPiper PA-38-112 · S/N 38-79A0934Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1979 · Rakowski Thomas P N118HBeech B35 · S/N D-2326Cancelled Aug 28, 2014 · Registration expired, pending cancellation · Built 1950 · Constantz Frederick B N56KBPitts Aerobatics S-2B · S/N 5096Cancelled Mar 27, 2014 · Exported to Canada · Allison Daniel S Trustee N136LRShort Bros SHORTS SD3-60 · S/N SH3752Cancelled Oct 28, 2013 · Exported to Democratic Republic of the Congo · Built 1989 · Acc Integrated Services Inc N133RACessna/Raven A-37 · S/N 67-14533Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Condor Corp N134RACessna/Raven A-37 · S/N 67-14534Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Condor Corp N136RACessna/Raven A-37 · S/N 67-14536Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Condor Corp N151ZLPiper PA-23-250 · S/N 27-3990Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1968 · Milwaukee Area Technical College N1213GLeppien Todd R CHALLENGER II · S/N CH2 1195Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Leppien Todd R N138RACessna/Raven A-37 · S/N 67-14538Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Condor Corp N128RACessna/Raven A-37 · S/N 67-14528Cancelled Aug 14, 2013 · Registration expired, pending cancellation · Condor Corporation N5878Morane-Saulnier MS760B · S/N 106Cancelled Aug 7, 2013 · Sale reported, canceled · Built 1964 N6267UMooney M20C · S/N 2247Cancelled Aug 5, 2013 · Revoked, canceled · Built 1962 · Ryan Peter D N3811ASchweizer SGS 1-26 · S/N 72Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1958 · Anderson Paul C N4301KBeaver RX Enterprises RX-550 · S/N BRX0134Cancelled Jul 11, 2013 · Sale reported, canceled N26404Grumman American Avn. AA-5A · S/N AA5A0567Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1978 · Fest Electronics Inc N704YJCessna 150M · S/N 15078976Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1976 · Verhunce John A III N7411WBalloon Works FIREFLY 7 · S/N F7-298Cancelled Jul 3, 2013 · Registration expired, pending cancellation · Powers Daron N4665ZStier Earl L RS-15 · S/N 101Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Anderson Paul C N9390TCessna T303 · S/N T30300009Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1981 · Mejia Tatian N155MAMitsubishi MU-2B · S/N 014Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1966 · Milwaukee Area Technical College N95728Taylorcraft BC12-D · S/N 8028Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1946 · Morris S John N622GLLarson G/Larson A MURPHY REBEL · S/N 622R3Cancelled May 16, 2013 · Registration expired, pending cancellation · Larson Greg A N164MCBeech 60 · S/N P-12Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1968 · Milwaukee Area Technical College N829HMoth 60-GM · S/N 1-RCancelled May 14, 2013 · Registration expired, pending cancellation · Built 1929 · Patrick Robert N N71940Luscombe 8A · S/N 3367Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1946 · Bertschinger Richard A N60EZPascarella John C VARIEZE · S/N 555-46-7497Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1979 · Pascarella John C N5559QJeason Martin W QUICKSILVER MXL 2 · S/N 2083Cancelled Apr 2, 2013 · Sale reported, canceled · Built 1984 N1932SIngram Skot SPAD XIII · S/N 234Cancelled Mar 26, 2013 · Sale reported, canceled N341DACessna 421 · S/N 421-0181Cancelled Mar 25, 2013 · Sale reported, canceled · Built 1968 N81197Brown Mark D STAR LITE · S/N 100Cancelled Feb 21, 2013 · Sale reported, canceled N72047Luscombe 8A · S/N 3474Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1946 N372ACShort Bros SD-360-300 · S/N SH3720Cancelled Feb 12, 2013 · First renewal notice · Built 1987 · Acc Integrated Services Inc N617FBShort Bros SHORTS SD3-60 · S/N SH3617Cancelled Feb 12, 2013 · First renewal notice · Built 1983 · Acc Integrated Services Inc N51083Cessna 150J · S/N 15069751Cancelled Dec 11, 2012 · Sale reported, canceled · Built 1968 N86BBBrown Robert A SONERAI II · S/N 900Cancelled Dec 11, 2012 · Sale reported, pending cancellation · Built 1982 N4204PPiper PA-23-160 · S/N 23-1693Cancelled Nov 7, 2012 · Sale reported, canceled · Built 1959 N6863DDehavilland VAMPIRE · S/N 17020Cancelled Oct 11, 2012 · Sale reported, pending cancellation N9426AHiller UH-12E · S/N 1001Cancelled Sep 28, 2012 · Registration pending, canceled · Built 1957 N5873UPiper PA-28-140 · S/N 28-26705Cancelled Sep 27, 2012 · Sale reported, pending cancellation · Built 1970

Back to Milwaukee, WI