Cancelled registrations · 18

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 = 'NC' AND d.registrant_city = 'WILSON' 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 = 'NC' AND d.registrant_city = 'WILSON'
  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 = 'NC' AND d.registrant_city = 'WILSON'
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.

N4210TLattimer Gene CYGNET SF-2A · S/N 367Cancelled Jun 19, 2021 · Sale reported, canceled · Built 2001 N7162HPiper J3C-65 · S/N 20415Cancelled Jan 31, 2020 · Revoked, canceled · Built 1946 · Wilson Air Svc Inc N9041UHiller-Tri-Plex Ind.Inc. UH-12B · S/N 359Cancelled Feb 27, 2018 · Registration pending, canceled N592GMMiller Geran FISHER 404 · S/N 001Cancelled Aug 21, 2014 · Sale reported, canceled N6464HPiper J3C-65 · S/N 19646Cancelled Aug 7, 2013 · Revoked, canceled · Built 1946 · Wilson Air Svc And Sales Inc N10102Moncrief William S 404 FISHER · S/N 4132Cancelled Sep 12, 2012 · Registration pending, canceled · Built 2001 N34902Cessna 177B · S/N 17702076Cancelled Jul 22, 2011 · Revoked, canceled · Built 1974 · Adams Lloyd N722PPRaytheon A36 · S/N E3516Cancelled Mar 2, 2011 · Exported to Brazil · Baker Mechanical Inc N8105QWood Callbie Franklin WOOD LSA 1 · S/N 1Cancelled Jun 9, 2009 · Triennial form not returned · Wood Callbie Franklin N2135LCessna 182T · S/N 18281652Cancelled Feb 26, 2008 · Built 2005 · Performance Aviation Of Wilson LLC N954PBBowers Scott P VELOCITY SR6E · S/N DMO325Cancelled Jul 21, 2003 · Built 2001 · Bowers Scott P N67CDEccker Donald E RANS S-10 · S/N 0191122Cancelled Apr 2, 1997 · Moncrief William S N8092FCessna 150F · S/N 15064192Cancelled May 2, 1972 · Brown Graham W N30802Piper J4F · S/N 4-1223Cancelled Aug 20, 1964 · Built 1940 · Lewis Paul N72476Cessna 140 · S/N 9644Cancelled Mar 16, 1956 · Wilson Air Service & Sales Inc N2299HErcoupe 415-C · S/N 2924Cancelled Nov 21, 1955 · Built 1946 · Wilson Air Services & Sales Co N46359Fairchild M-62A · S/N T43-5972Cancelled Nov 17, 1955 · Built 1945 · Wilson Air Service & Sales Inc N16567Aeronca C-3 · S/N 704Cancelled Aug 4, 1948 · Williamson Ralph E

Back to Wilson, NC