Cancelled registrations · 22

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

N4828RCessna A188B · S/N 18802347TCancelled Dec 15, 2022 · Exported to Kazakhstan · Built 1975 · Burkett Joe E N6861QBeech S35 · S/N D-7476Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Built 1964 · Hall Thomas C N2035JWeatherly 620B · S/N 1592Cancelled Aug 14, 2017 · First renewal notice · Built 1995 · Burkett Joe DBA N5401CCessna 170A · S/N 19435Cancelled May 20, 2015 · Registration pending, canceled N45173Cessna 150M · S/N 15076769Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1975 · Rosales Gabriel D N6425SCessna 150H · S/N 15067225Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1967 · Day Kenny DBA N188KFLaws William R KITFOX IV · S/N ADS-161Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1994 · Laws W R N6262ACessna 182 · S/N 33062Cancelled Aug 7, 2013 · Revoked, canceled · Built 1956 · Bishop Oreal D N8362Lockheed T-33A · S/N 56-1574Cancelled Mar 18, 2013 · Sale reported, pending cancellation N44EHHart KR-1 · S/N 4372Cancelled Nov 9, 2012 · Sale reported, canceled · Built 1978 N7477Lockheed T-33A · S/N 56-1573Cancelled Aug 13, 2012 · Sale reported, pending cancellation N3815JCessna 150G · S/N 15065115Cancelled Jun 7, 2010 · Triennial form not returned · Built 1966 · Day Cecil C N3050JCessna 150E · S/N 15061150Cancelled Oct 12, 2004 · Built 1965 · Lane Donald H N36SFHawker SEA FURY TMK 20 · S/N 37539Cancelled Aug 3, 2001 · Exported to United Kingdom · Bradshaw Barbara A N809YGreat Lakes 2T-1A · S/N 178Cancelled Jan 20, 1976 · Upton Newman J N6671XCessna 210A · S/N 21057671Cancelled Dec 4, 1965 · Birdwell Jack D N90510Beech D18S · S/N A-375Cancelled Feb 9, 1962 · Exported to Spain · Lee Robert E Jr N36546Aeronca 65-TC · S/N 10261Cancelled Jun 10, 1949 · Built 1941 · Showers I G N47921Fairchild M-62A · S/N 8003AECancelled Oct 15, 1948 · Gilliam Ray N24NStar CAVALIER · S/N 114Cancelled Mar 2, 1948 · C C Mckeever N2342EAeronca 7AC · S/N 7AC-5920Cancelled Feb 24, 1948 · Ray Gilliam DBA Coleman Flying School N32411Porterfield LP-65 · S/N 841Cancelled Nov 15, 1944 · Built 1940 · Yates H M

Back to Coleman, TX