Skip to content

Cancelled registrations · 161

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 = 'IL' AND d.registrant_city = 'WHEELING' 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 = 'IL' AND d.registrant_city = 'WHEELING'
  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 = 'IL' AND d.registrant_city = 'WHEELING'
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.

N6899JPiper PA-28-140 · S/N 28-7625253Cancelled Dec 13, 1977 · Chicagoland Airport Inc N87105Ercoupe 415-C · S/N 278Cancelled Jul 18, 1977 · Hay Stephen M N100GPLockheed 18-56 · S/N 2571Cancelled Apr 21, 1977 · George J Priester N654QBeech 95 · S/N TD-202Cancelled Oct 1, 1976 · Exported to Canada · Graubart Eli N6353SCessna 150G · S/N 15067153Cancelled Aug 2, 1976 · Exported to Canada · Priester George J N22999Cessna 150H · S/N 15068671Cancelled Jun 11, 1976 · Exported to Canada · Built 1968 · George J Priester Aviation Service N23054Cessna 150H · S/N 15068702Cancelled Jun 11, 1976 · Exported to Canada · Built 1968 · Priester George J N3080SCessna 150G · S/N 15066980Cancelled Jun 11, 1976 · Exported to Canada · Built 1967 · Priester George J N5503GCessna 150 · S/N 15071003Cancelled Jun 8, 1976 · Exported to Canada · George J Priester Aviation Service N61065Cessna 150J · S/N 15070776Cancelled Jun 8, 1976 · Exported to Canada · Priester J George Aviation Service N60322Cessna 150J · S/N 15070225Cancelled Jun 7, 1976 · Exported to Canada · George J Priester Aviation Service N60325Cessna 150J · S/N 15070226Cancelled Jun 7, 1976 · Exported to Canada · George J Priester Aviation Service N7982GCessna 172L · S/N 17259682Cancelled Aug 14, 1975 · Exported to Canada · Eli Graubart DBA Air Exchange N7030GCessna 172K · S/N 17258730Cancelled May 2, 1975 · Exported to Canada · Eli Graubart DBA Air Exchange N74702Mooney M20B · S/N 1702Cancelled Apr 15, 1975 · Exported to Canada · Air Exchange N77111Piper PA-28-180 · S/N 28-5352Cancelled Apr 15, 1975 · Exported to Canada · Graubart Eli N8929TCessna 182C · S/N 52829Cancelled Oct 7, 1974 · Exported to Canada · Graubart Eli N3076SCessna 150G · S/N 15066976Cancelled Dec 18, 1973 · Built 1967 · Priester George J N40297Piper PA-23-250 · S/N 27-7305112Cancelled Jul 11, 1973 · Exported to United Kingdom · Graubart Eli N3552VCessna 140 · S/N 14827Cancelled Jun 22, 1973 · Roche Jr Thomas Patrick N7604QCessna 310Q · S/N 310Q0609Cancelled May 3, 1973 · Exported to United Kingdom · Brooks Robert L & Charles E Priester N252MDCessna 336 · S/N 336-0061Cancelled Apr 12, 1973 · Exported to Canada · Air Exchange N14367Piper PA-23-250 · S/N 27-7304954Cancelled Mar 2, 1973 · Exported to United Kingdom · Air Exchange N89896Cessna 140 · S/N 8941Cancelled Jun 13, 1972 · George Priester J N1263ZBeech B95A · S/N TD-454Cancelled Mar 2, 1972 · Exported to Canada · Air Exchange N5951BCessna 182A · S/N 33951Cancelled Feb 23, 1972 · Priester George J N61102Beech AT-11 · S/N 3311Cancelled Feb 23, 1972 · Priester George J N697RCPiper PA-23-250 · S/N 27-4344Cancelled Feb 16, 1972 · Exported to United Kingdom · Built 1969 · Air Exchange N7695TCessna 172A · S/N 47295Cancelled Dec 28, 1971 · Priester George J N2159PPiper PA-23 · S/N 23-761Cancelled Dec 20, 1971 · Priester George N8038MCessna 310I · S/N 31010038Cancelled Sep 11, 1971 · Priester George J N3440KPiper J3C-65 · S/N 22131Cancelled Aug 18, 1971 · Balling C D N1883HCessna 310C · S/N 35983Cancelled Jul 13, 1971 · Muntz Tv Inc N6352SCessna 150G · S/N 15067152Cancelled Mar 25, 1971 · Sallys Flying School Inc N9257DPiper PA-18 · S/N 18-6550Cancelled Feb 24, 1971 · Chicagoland Airport Inc N3872EAeronca 7AC · S/N 7AC-7100Cancelled Oct 16, 1970 · Chicagoland Airport Inc N97406Stinson 108 · S/N 108-406Cancelled Sep 10, 1970 · Priester George J N5267HPiper PA-16 · S/N 16-71Cancelled Sep 8, 1970 · Built 1949 · Priester George J N8356XCessna 172C · S/N 17248856Cancelled Sep 3, 1970 · Priester George J N60080Grumman G-44 · S/N 1357Cancelled Sep 2, 1970 · Priester George J N794BBeech A35 · S/N D-1806Cancelled Sep 2, 1970 · Built 1948 · Priester George J N7026HPiper J3C-65 · S/N 20271Cancelled Jun 12, 1970 · Sallys Flying School N70751Piper J3C-65 · S/N 17768Cancelled Jun 12, 1970 · Sallys Flying School N98743Piper J-3 · S/N 18969Cancelled Jun 12, 1970 · Built 1946 · Sally'S Flying School N42978Piper J3C-65 · S/N 15337Cancelled Dec 12, 1967 · Salleys Flying School Inc N92109Piper J3C-65 · S/N 16546Cancelled May 21, 1965 · Palwaukee Aviation Corp N7449CNorth American T-28A · S/N 50-318ACancelled Jul 28, 1964 · Exported to Nicaragua · Priester George J N5490HPiper PA-18 · S/N 18-81Cancelled Apr 3, 1958 · Chicagoland Airport Inc N3430MPiper PA-12 · S/N 12-2271Cancelled May 17, 1957 · Priester George J N4596VBeech 35 · S/N D-1144Cancelled May 7, 1957 · George J Priester

Back to Wheeling, IL