Skip to content

East Lansing, MI

Cancelled registrations · 44

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 = 'MI' AND d.registrant_city = 'EAST LANSING' 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 = 'MI' AND d.registrant_city = 'EAST LANSING'
  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 = 'MI' AND d.registrant_city = 'EAST LANSING'
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.

N310WNCessna 310P · S/N 310P0007Cancelled Jun 10, 2023 · Sale reported N782NMDJI PHANTOM 2 · S/N BA272055108274Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Michigan State University N148RSDJI PHANTOM 2 · S/N DJIP211849Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Michigan State University N680BMDJI PHANTOM 2 VISION + · S/N PH645248449 V2.0Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Michigan State University N695RSAeromao AEROMAPPER · S/N AMEV2-019Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Michigan State University N4102MPiper PA-12 · S/N 12-2997Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 1947 · Carr George M N14022Aerofab LAKE LA-250 · S/N 27Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1985 · Carr George M N6019DJI PHANTOM 4 · S/N 07DDD6J0B11343Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Vander Galien Todd R N30972Piper J4A · S/N 41247Cancelled Jun 26, 2020 · Revoked, canceled · Built 1940 · Sheppard Isaac Jr N7807MDJI PHANTOM 2 VISION + · S/N PH645501983Cancelled Dec 2, 2019 · Registration expired, pending cancellation · Michigan State University N298RSMichigan State University RSGIS-QUAD-01 · S/N 2016021855Q1Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Michigan State University N750FBMichigan State University EGR-QUAD-0001 · S/N MSUQ0001Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Michigan State University N753QMMichigan State University EGR-QUAD-0005 · S/N MSUQ0005Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Michigan State University N766MMAlign TREX 450 PLUS DFC · S/N L143052075Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Michigan State University N769EMMichigan State University EGR-QUAD-0002 · S/N MSUQ0002Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Michigan State University N20340Taylorcraft A · S/N 441Cancelled Nov 1, 2019 · Revoked, canceled · Ives Richard William N552RSMichigan State University RSGIS-QUAD-02 · S/N 2016021855Q2Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Michigan State University N680FMDJI PHANTOM 3 PROFESSION · S/N P76DCD27011633Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Michigan State University N753RMMichigan State University EGR-QUAD-0003 · S/N MSUQ0003Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Michigan State University N756WMMichigan State University EGR-QUAD-0004 · S/N MSUQ0004Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Mighigan State University N790RS3D Robotics X8+ · S/N X815031910004Cancelled Mar 14, 2019 · Registration expired, pending cancellation · Michigan State University N690RS3D Robotics X8 RTF · S/N 3DRRTFX8R636648604Cancelled Mar 12, 2019 · Registration expired, pending cancellation · Michigan State University N6548KDowner REPUBLIC RC-3 · S/N 814Cancelled May 7, 2013 · Revoked, pending cancellation · Built 1947 · Winter Henry M N51231Cessna 172P · S/N 17274284Cancelled Sep 17, 2012 · Exported to Tanzania · Built 1980 · Seif Ali M N73668Cessna 172N · S/N 17267602Cancelled Sep 17, 2012 · Exported to Tanzania · Built 1976 · Seif Ali M N6374HAerostar International RX-7 · S/N RX7-3224Cancelled Aug 22, 2012 · Registration expired, pending cancellation · Built 1992 · Outta Bounds Inc N999WCStart & Flug H101 "SALTO" · S/N 56Cancelled Jul 26, 2000 · Exported to Canada · Stetson Jeffry W N96030Bell UH-1B · S/N 63-8547Cancelled Mar 15, 1991 · Michigan Department Of State Police N207AHartman HOT AIR BALLOON · S/N 3Cancelled Sep 13, 1981 · Sproat Lloyd E N1703VCessna 120 · S/N 13888Cancelled Mar 31, 1972 · Exported to Canada · Gay Richard L N5581TCessna 172E · S/N 17251481Cancelled Feb 28, 1972 · Winged Spartans Inc N4674JPiper PA-28R-180 · S/N 28R-30575Cancelled Jul 12, 1971 · Exported to Canada · Thomas Robert M N79YCessna T-50 · S/N 4989Cancelled Nov 23, 1970 · Hajicek Robert L N2652UCessna 172 · S/N 17250252Cancelled Jun 29, 1970 · Connally Linda L N5833NBoeing PT-13D · S/N 75-5563Cancelled May 25, 1960 · C A P Michigan Wing N5840NBoeing PT-13D · S/N 75-5138Cancelled May 25, 1960 · C A P Michigan N6737MStinson 108-3 · S/N 108-4737Cancelled Mar 3, 1959 · Lanting R N98456Piper J3C-65 · S/N 18652Cancelled Feb 27, 1956 · Graham Gerald E N9203EAeronca 11AC · S/N 11AC-837Cancelled Oct 6, 1955 · Built 1946 · Winged Spartans N6340KRepublic RC-3 · S/N 564Cancelled Aug 6, 1952 · Spencer Perry N49523Consolidated Vultee BT-15 · S/N 7439Cancelled Jun 29, 1951 · Arthur J Davis N23464Piper J4A · S/N 4-623Cancelled Jun 10, 1948 · Gaffka Thomas George N6092Travel Air Mfg 2000 · S/N 596Cancelled Mar 7, 1930 · Built 1928 · O'Dell Ernest N4139Thomas Morse WACO 9 · S/N I-1024Cancelled Dec 28, 1928 · Davis Arthur J

Back to East Lansing, MI