Skip to content

Cancelled registrations · 215

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 = 'NE' AND d.registrant_city = 'LINCOLN' 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 = 'NE' AND d.registrant_city = 'LINCOLN'
  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 = 'NE' AND d.registrant_city = 'LINCOLN'
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.

N999FZDJI MAVIC AIR 2 · S/N 1581F3N3FJ5P002L0050Cancelled Jan 4, 2025 · Sale reported, canceled N351RZDJI AGRAS T30 · S/N 1581F446LJ4B20L00KU0Cancelled Oct 10, 2024 · Frontier Cooperative N356RZDJI AGRAS T30 · S/N 3U5BJ4J00100FCCancelled Feb 28, 2024 · Frontier Corp N22859Cessna 150H · S/N 15068568Cancelled Oct 31, 2023 · Freeman Jonathan T N534RCBombardier CL-600-2B16 · S/N 5342Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Duncan Aviation Inc N4580ADraganfly Innovations DRAGANFLYER X4ESN-1G · S/N AF3340Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Olsson Associates N6810ADraganfly Innovations DRAGANFLYER X4ESN-1G · S/N 465CDECancelled Jun 4, 2022 · Registration expired, pending cancellation · Olsson Associates N206HPBell 206B · S/N 72-21093Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Nebraska State Patrol N110NUUas USA TEMPEST · S/N 0814141Cancelled Jul 3, 2021 · Registration expired, pending cancellation · University Of Nebraska Lincoln N210NUUas USA TEMPEST · S/N 1129121Cancelled Jul 3, 2021 · Registration expired, pending cancellation · University Of Nebraska Lincoln N310NUAerial Technology Intl DROIDWORKS AD-8 · S/N 0033932400Cancelled Jul 3, 2021 · Registration expired, pending cancellation · University Of Nebraska - Lincoln N97NGDJI MAVIC PRO · S/N 08QDD9MA1200PVCancelled Jul 3, 2021 · Registration expired, pending cancellation · Uav Advantage LLC N2005YNational Ballooning 858 · S/N 133Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Built 2000 · Re/Max Promotional Fund Inc N144KBBaker Kevin P BABY GREAT LAKES · S/N 7905-M-764BCancelled May 1, 2020 · Registration expired, pending cancellation · Built 1982 · Baker Kevin P N667QNDJI PHANTOM 2 · S/N PH645182097Cancelled Nov 4, 2019 · Registration expired, pending cancellation · College Of Journalism And Mass Communications N740JNDJI PHANTOM 3 ADVANCED · S/N P77DCF24013590Cancelled Sep 6, 2019 · Registration expired, pending cancellation · University Of Nebraska Lincoln N7940ADJI INSPIRE 1 PRO · S/N W21ACI16011527Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Olsson Associates N725WDJI PHANTOM 2 VISION + · S/N PH645339162 V2.0Cancelled Aug 6, 2019 · Third renewal notice · Sundance Aviation LLC N6204ECessna 172 · S/N 46304Cancelled May 29, 2019 · Sale reported · Built 1958 N260LFLearjet 31 · S/N 015Cancelled Mar 26, 2019 · Built 1990 · Landscapes Unlimited LLC N81490Aeronca 7AC · S/N 7AC-111Cancelled Dec 6, 2018 · Revoked, pending cancellation · Built 1945 · Flight Line Inc N90208Ramler Fred A VOLKSPLANE · S/N VP1LP30Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Built 1981 · Eggerling Darrell H N9103RAerostar International RAVEN S57-A · S/N S57A-3149Cancelled Sep 14, 2018 · Registration expired, pending cancellation · Built 1993 · Re/Max Promotions Fund Inc N11865Bellanca 7ECA · S/N 830-72Cancelled Feb 27, 2018 · Registration expired, pending cancellation · Built 1972 · Korver Justin P N6432MCessna 152 · S/N 15284724Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 1980 · Capitol Aviation Inc N76480Cessna 140 · S/N 10912Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Jackson J W N9027BAeronca 7FC · S/N 7FC119Cancelled Feb 4, 2017 · Revoked, canceled · Built 1957 · Fleming Henry C N999ZFZidek John Jay VANS RV-4 · S/N 2407Cancelled Oct 13, 2016 · First renewal notice · Built 1996 · Allder Jerry A N102MBDebus J/Mountain S/Bowes E DEBUS-CASST-SNOSHOO · S/N DMB-001Cancelled Aug 26, 2016 · Third renewal notice · Miss Lynn Racing LLC N383UCCox John F TITAN TORNADO SS · S/N SS07J22S0HK0524Cancelled Feb 25, 2015 · Third renewal notice · Cox John F N8760Swallow TP · S/N 160Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1929 · Redden Gary P N2291GCessna 182B · S/N 51591Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1958 · Lincoln Sport Parachute Club Inc N8229VPiper PA-28-181 · S/N 28-8090331Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1980 · Lincoln Aire Inc N5672RRaven Industries RX6 · S/N RX6-301Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1978 · Lincoln Parachutes Balloon Loft N500RMMayberry Randall Brent ROTORWAY EXEC 90 · S/N 5064Cancelled Jul 30, 2013 · Sale reported, canceled · Built 1992 N1993SCameron Balloons US O-77 · S/N 5295Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1987 · Cidlik John P N3027DCessna 310 · S/N 35227Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1955 · Capitol Aviation Inc N9296KPiper PA-32R-300 · S/N 32R-7680206Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1976 · Eagle Has Landed Inc N6624MStinson 108-3 · S/N 108-4624Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1948 · Becker Steven P N4873PPiper PA-23-250 · S/N 27-452Cancelled Mar 18, 2013 · Registration expired, pending cancellation · Built 1961 · Grady Gil N7153BErickson Warren M TEENIE TWO · S/N 061190Cancelled Feb 11, 2013 · Sale reported, pending cancellation N8671LRaven Industries RX6 · S/N RX6-153Cancelled Nov 14, 2012 · Sale reported, pending cancellation · Built 1975 N20MXPiper PA-23-250 · S/N 27-7754007Cancelled Nov 6, 2012 · Registration expired, pending cancellation · Built 1976 · Lincolnnaire Inc N48758Ryan Aeronautical ST3KR · S/N 1781Cancelled Aug 8, 2012 · Revoked, canceled · Built 1942 · Richard C And Robert L Headley N4441APiper PA-22-150 · S/N 22-3771Cancelled Jul 9, 2012 · Revoked, canceled · Built 1956 · State Securities Company N72DAGates Learjet 35A · S/N 098Cancelled Jan 23, 2012 · First renewal notice · Built 1976 · Duncan Aviation Inc N824SPCessna 172S · S/N 172S8738Cancelled Aug 11, 2011 · Exported to Canada · Built 2001 · Performance Aircraft Sales Inc N1728XCessna T210L · S/N 21060750Cancelled Dec 13, 2010 · Exported to Mexico · Built 1975 · Commercial Contractors Equipment Inc N4365ZPiper PA-28RT-201T · S/N 28R-8431028Cancelled May 13, 2010 · Exported to Canada · Built 1984 · Craig Ronald D N1921XCessna 182H · S/N 18256021Cancelled Jan 5, 2010 · Triennial form not returned · Built 1965 · Lincoln Sport Parachute Club Inc

Back to Lincoln, NE