Skip to content

Cancelled registrations · 158

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 = 'TX' AND d.registrant_city = 'ODESSA' 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 = 'TX' AND d.registrant_city = 'ODESSA'
  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 = 'TX' AND d.registrant_city = 'ODESSA'
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.

N1PYFlewelling George AVID FLYER · S/N 238Cancelled Dec 14, 2024 · Sale reported, canceled N8004ZCessna U206 · S/N U206-0404Cancelled May 10, 2023 · Revoked, pending cancellation · Built 1965 · Sachse L A N7991LBeech A23-24 · S/N MA-154Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 1966 · Rathbun Daniel F N534ZFRobert Bert Farmer RB5 · S/N 1408Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Farmer Robert B N2799ARaven Industries RALLY RX7 · S/N RX7-438Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 1986 · Abbott Mark N N6151FCessna 210H · S/N 21059051Cancelled Jan 11, 2021 · Registration expired, pending cancellation · Built 1968 · Vaught Gary N2375FCessna 210E · S/N 21058575Cancelled Jun 19, 2020 · Revoked, canceled · Built 1965 · Sachse Max E N50562Aeronca L-3C · S/N 058B7122Cancelled Jan 10, 2020 · Revoked, canceled · Alexander Billy C N29897Taylorcraft BF · S/N 2750Cancelled Nov 8, 2019 · Revoked, canceled · Built 1941 · Ballard Homer N24458Taylorcraft BL-65 · S/N 1795Cancelled Nov 1, 2019 · Revoked, canceled · Built 1940 · Darnell Jimmy N1118CPiper PA-18A-135 · S/N 18-2206Cancelled Oct 18, 2019 · Revoked, canceled · Built 1953 · Driggers H D N3112FCessna 182J · S/N 18257212Cancelled Oct 18, 2019 · Revoked, pending cancellation · Built 1966 · Sachse L A N8234RBellanca 17-30A · S/N 30409Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Built 1971 · Nabarrette Angel N122JAAndrews Joseph C JR VAN RV-4 · S/N 2113Cancelled Sep 6, 2019 · Sale reported, canceled · Built 1995 N7131KPiper PA-18-105 SPECIAL · S/N 18-349Cancelled May 13, 2019 · Revoked, pending cancellation · Built 1950 · Madden W E N4858BCessna 310 · S/N 35158Cancelled Mar 11, 2019 · Registration expired, pending cancellation · Built 1955 · Jp & Sons Oilfield Service LLC N2933BBeech D35 · S/N D-3574Cancelled May 18, 2018 · Revoked, canceled · Built 1953 · Rainer James W Dr N2909PPiper PA-22-150 · S/N 22-3177Cancelled Mar 23, 2018 · Revoked, canceled · Built 1955 · Myers Collins Hood & Cruse N493SFRobert B Farmer WANAGO · S/N 1408Cancelled Mar 16, 2018 · Registration expired, pending cancellation · House Jerry D N97142Stinson 108 · S/N 108-142Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1946 · Spengler Raymond Francis Jr N4469GFarmer R B VXP ONE · S/N 1408Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Farmer Robert B N2955BPiper PA-28RT-201T · S/N 28R-7931274Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1979 · Graves Martin D N3853HEngineering & Research ERCOUPE 415-CD · S/N 4554Cancelled Nov 22, 2017 · Revoked, canceled · Built 1947 · Tull Leon E N8242UCessna 172F · S/N 17252142Cancelled Nov 21, 2017 · Revoked, canceled · Built 1964 · Sachse L A N8VGGagnon Joseph V KITFOX IV SPEEDSTER · S/N HCS-126Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1996 · Thurman Roger L N5054RWatson Benny AIR · S/N 1Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Watson Benny N8918CPiper PA-22-135 · S/N 22-1513Cancelled Jun 13, 2017 · Registration expired, pending cancellation · Built 1953 · Purdy Doris J N38366Burkhart Grob Flugzeugbau G103 TWIN ASTIR · S/N 3760Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1983 · Batch Juan R N6177TCessna 150E · S/N 15060877Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1964 · Jackson Jean P N3586GCallair A-9 · S/N 1179Cancelled Mar 7, 2017 · Registration expired, pending cancellation · Built 1965 · Nelson Ronald A N62789Farmer R B FARMER/D5CY · S/N A19CYCancelled Feb 16, 2017 · Registration expired, pending cancellation · Farmer Robert B N925APiper PA-22 · S/N 22-230Cancelled Feb 4, 2017 · Revoked, pending cancellation · Built 1951 · Pinkies Liquor Stores Inc N1615YCessna 172C · S/N 17249315Cancelled Sep 14, 2016 · Revoked, canceled · Built 1962 · Sachse Max N3709YCessna 210C · S/N 21058209Cancelled Feb 22, 2016 · Third renewal notice · Built 1963 · Vaught Gary S N45BDBeech 70 · S/N LB24Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1969 · Qpmb Inc N28LPLaister Sailplane Products LP-49 · S/N K28Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1971 · Nelson Ronald A N63117Farmer Robert Bert BD5B · S/N 1638Cancelled May 15, 2015 · Registration expired, pending cancellation · Farmer Robert B N2637APiper PA-22-135 · S/N 22-907Cancelled May 13, 2015 · Registration expired, pending cancellation · Bowden William R Jr N7182KFarmer Robert B POLLIWAGEN · S/N 7053Cancelled May 5, 2015 · Registration expired, pending cancellation · Farmer Robert B N9317SBeech B19 · S/N MB-768Cancelled Apr 27, 2015 · Registration expired, pending cancellation · Built 1975 · Fox Charles R N2902GCallair A-5 · S/N 257Cancelled Dec 22, 2014 · Revoked, canceled · Built 1959 · Bright Barrett E N63MCHiller UH-12C · S/N 915Cancelled Dec 16, 2014 · Registration pending, canceled N4219AMuxworthy John CHRISTEN EAGLE-II · S/N MUXWORTHY-0001Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Muxworthy John N5576SBates Marcus & Mary BUCKER 1.131 · S/N MB-30Cancelled Oct 28, 2014 · Registration expired, pending cancellation · Bates Marcus L N34889Cessna 177B · S/N 17702067Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1974 · Permian Rat Hole Drilling Inc N2818HSchweizer SGS 1-35C · S/N 78Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1977 · Batch Juan R N5968FPiper PA-28-181 · S/N 28-7790147Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1976 · Six Eight Foxtrot N3454ZPiper PA-22-150 · S/N 22-7373Cancelled Oct 25, 2013 · Registration expired, pending cancellation · Built 1960 · Pullen Dulcie M N6644AWSK Pzl-Krosno KR-03A · S/N 03-04Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1991 · Batch Juan R N4819YRiley Robert L SR BENSEN B-8MG · S/N 1Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1985 · Blair James R

Back to Odessa, TX