Cancelled registrations · 26

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 = 'NE' AND d.registrant_city = 'SCOTTSBLUFF' 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 = 'NE' AND d.registrant_city = 'SCOTTSBLUFF'
  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 = 'NE' AND d.registrant_city = 'SCOTTSBLUFF'
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.

N42575Quicksilver QUICKSILVER SPORT II · S/N 339Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Dietrich Ryan N6524PPiper PA-24-250 · S/N 24-1646Cancelled Jan 22, 2019 · Revoked, canceled · Built 1959 · Langley J T N21DQOstry Joseph E LONG EZ · S/N 556Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1982 · Ostry Joseph E N6693ABeech B-60 · S/N P-527Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1979 · Rice Air LLC N5989VPiper J3C-65 · S/N 12916Cancelled Aug 30, 2012 · Revoked, canceled · Civil Air Patrol Nebraska Wg N8338QRobinson Helicopter R22 BETA · S/N 2614Cancelled Sep 26, 2000 · Exported to Australia · Scottsbluff Mortgage Loan Company N6606QGrumman Acft ENG Cor-Schweizer G-164B · S/N 133BCancelled Apr 18, 1983 · Exported to Canada · Reisig Brothers Aerial Spraying Inc N8807SCessna 150F · S/N 15062107Cancelled Jul 18, 1977 · Stanko Henry L Jr N9637HCessna 172M · S/N 17266284Cancelled Apr 15, 1977 · Exported to Canada · Built 1975 · Scottsbluff Aviation Co Inc N4417APiper PA-22-150 · S/N 22-3745Cancelled Jan 21, 1971 · Built 1956 · Valley Flying Club Inc N7213CNorth American AT-6D · S/N 42-85488Cancelled Jan 4, 1971 · Quate Boyd E N38479Piper J3F-65 · S/N 7052Cancelled Oct 7, 1970 · Samuel Schlothauer N67907Douglas A-26B · S/N 28036Cancelled Oct 22, 1965 · Banner Oil Co Inc N73761Convair BT-13A · S/N 6255Cancelled May 20, 1965 · Don West N7094CNorth American SNJ-4 · S/N 88-13264Cancelled Oct 9, 1963 · Exported to Panama · Boyd E Quate N5440ACessna 310B · S/N 35640Cancelled Mar 10, 1961 · Exported to Canada · Houk Earl N2925VBeech 35 · S/N D-308Cancelled Aug 26, 1953 · Midwest Amusement & Realty Co N5991VPiper J-3 · S/N 9957Cancelled Jul 30, 1953 · Scottsbluff Squadron Civil Air Patrol Inc N3042EAeronca 7AC · S/N 7AC-6628Cancelled Jan 26, 1951 · Bluffs Aviation Sales Co N3067EAeronca 7AC · S/N 7AC6656Cancelled Jan 26, 1951 · Built 1946 · Bluffs Aviation Sales Co N99901Engineering & Research 415-C · S/N 2524Cancelled Aug 15, 1949 · Forsyth Thomas N48480Piper J3C-65 · S/N 11018Cancelled Aug 5, 1949 · Bluffs Aviation Sales Co N86263Aeronca 11AC · S/N 11AC-68Cancelled Jun 17, 1949 · Bluffs Aviation Sales Co N25851Piper J3L · S/N 3804Cancelled May 28, 1943 · Aircraft Flying Club Number 2 N400WCessna CG-2 · S/N 89Cancelled Jan 12, 1933 · Hilliard L L N2292Travel Air Manufacturing BIPLANE · S/N 110Cancelled Sep 13, 1927 · Schafer Charles F

Back to Scottsbluff, NE