Skip to content

Cancelled registrations · 40

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 = 'JUSTIN' 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 = 'JUSTIN'
  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 = 'JUSTIN'
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.

N31446Aeronca 65-TL · S/N L5400TCancelled May 1, 2023 · Registration pending, canceled N9183LAeronca 65-TAF · S/N F2611TACancelled May 1, 2023 · Registration pending, canceled N80324Taylorcraft L-2M · S/N 5783Cancelled Oct 6, 2022 · Sale reported, canceled N1615UMinicab GY-20 · S/N AJ-1Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1966 · Currie Mark H N615CCHytek HURRICAN CLIP WNG HP · S/N HT-96-730Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1996 · Moore Jan R N1739NCessna 120 · S/N 11983Cancelled Apr 8, 2022 · Registration expired, pending cancellation · Built 1946 · Schauer John P N4265KRyan NAVION · S/N NAV-4-1265Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Clark James R N5534JMyers Jack MX SUPER · S/N 1007Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1984 · Moore Jan R N9540UGrumman American Avn. AA-1C · S/N AA1C0037Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 1977 · Pockrus Jerry D N53789Bellanca 7ECA · S/N 1118-75Cancelled Mar 26, 2018 · Registration expired, pending cancellation · Built 1975 · Pockrus Jerry D N900HBAeronca 7DC · S/N 7DC-93Cancelled Mar 19, 2018 · Registration expired, pending cancellation · Built 1948 · Pockrus Jerry D N7024WPiper PA-28-180 · S/N 28-708Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 1962 · Pockrus Jerry D N2859MLawson Thomas J AEROBAT - AF · S/N 1034DCancelled Feb 13, 2018 · Registration expired, pending cancellation · Lawson Thomas J N4835BCessna 152 · S/N 15283664Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1979 · Prop Holdings Inc N13KHHall Ken T HALL KEN ROTORWAY · S/N KTH13410Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1998 · Hall Ken T N6380KCessna 172P · S/N 17274189Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 1980 · Justin State Bank N2012BBeech C24R · S/N MC-600Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1978 · Nautics Aeronautics Astronautics &Technologies LLC N3653DAir Tractor AT-301 · S/N 301-0271Cancelled Nov 12, 2015 · Exported to Colombia · Built 1980 N233AWCarter Howard E FS-21000 · S/N 522Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Carter Howard E N71869Luscombe 8A · S/N 3296Cancelled Apr 10, 2015 · Third renewal notice · Built 1946 · Justin Seed Company Inc N8764PPiper PA-24-260 · S/N 24-4214Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1965 · Seek Ltd N14LULovasz ZENITH · S/N A194Cancelled Mar 20, 2014 · First renewal notice · Built 1978 · Pockrus Jerry Dale N5188PPiper PA-24 · S/N 24-210Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Seek Ltd N9013RCessna A188B · S/N 18802081TCancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1975 · Sitton Dwayne N73163Convair 440 · S/N 366Cancelled Aug 16, 2013 · Sale reported, canceled · Built 1956 N4865QCessna A188B · S/N 18802601TCancelled Aug 5, 2013 · Sale reported, canceled · Built 1976 N6164PPiper PA-24-250 · S/N 24-1265Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1959 · Seek Ltd N6092PPiper PA-24-250 · S/N 24-1192Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1960 · Seek Ltd N42402Cessna T188C · S/N T18803700Cancelled Mar 26, 2013 · Sale reported, canceled · Built 1980 N6999PPiper PA-24-250 · S/N 24-2143Cancelled Mar 25, 2013 · Registration expired, pending cancellation · Seek Ltd N9348RVertol PV18 · S/N 124-925Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1960 N8621Piasecki HUP-3 · S/N 147630Cancelled Nov 14, 2012 · Sale reported, pending cancellation N101PTSpurling John PRO-500T · S/N 001Cancelled Aug 30, 2012 · Registration pending, canceled · Built 2002 N9689ACessna 140A · S/N 15410Cancelled Jul 20, 2011 · Registration pending, pending cancellation · Built 1950 N835RVOrndorff G E III/Orndorff R S RV8 · S/N 80035-RV8Cancelled Oct 25, 2003 · Triennial form not returned · Orndorff George E III N9901GCessna A188A · S/N 18800701Cancelled Sep 3, 2003 · Second triennial mailing, no response · Built 1970 · Sitton Dwayne N57161Beech UC-45J · S/N 67161Cancelled Apr 30, 1992 · Second triennial mailing, no response · Hyde Charles G N4377LCessna 172G · S/N 17254455Cancelled Aug 28, 1991 · Exported to South Africa N1196PPiper PA-23 · S/N 23-211Cancelled Dec 11, 1982 · Administratively canceled · Clark L E DBA N2026PPiper PA-23 · S/N 23600Cancelled Nov 16, 1982 · Administratively canceled · Clark L E DBA

Back to Justin, TX