Cancelled registrations · 27

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 = 'CA' AND d.registrant_city = 'SAN BRUNO' 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 = 'CA' AND d.registrant_city = 'SAN BRUNO'
  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 = 'CA' AND d.registrant_city = 'SAN BRUNO'
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.

N854Roberts Jeff SUPER RV8 · S/N 81273Cancelled Mar 19, 2025 · Built 2002 · Senegal Steven L N107TSmith Miniplane DSA-1 · S/N 500Cancelled May 4, 2019 · Sale reported, canceled N9145KStinson 108-1 · S/N 108-2145Cancelled May 4, 2019 · Revoked, pending cancellation · Built 1947 · Lawson Lloyd N3855YCessna 210D · S/N 21058355Cancelled Mar 16, 2018 · Revoked, canceled · Built 1965 · Ruiz Rafael N8430MCessna A150K · S/N A15000130Cancelled Mar 16, 2018 · Revoked, canceled · Built 1969 · Braunberger Alfred S N4377GMcculloch J-2 · S/N 087Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1972 · Hochwarth Hans N3843PPiper PA-22-150 · S/N 22-3534Cancelled Sep 21, 2012 · Sale reported, canceled · Built 1955 N55002Piper PA-28-180 · S/N 28-7305289Cancelled Aug 23, 2012 · Revoked, canceled · Built 1973 · Whiteside A E N20899Herman Karyl B RV-6 · S/N 20163Cancelled Aug 21, 2012 · Registration pending, canceled N271RPMonaghan R/Monaghan P MONAGHAN GLASAIR · S/N 271Cancelled Jan 8, 2007 · Triennial form not returned · Built 2000 · Monaghan Robert E N103DHDouglas DC-6A · S/N 43699Cancelled Aug 31, 1984 · Administratively canceled · Dhl Corp N465MMartin 404 · S/N 14152Cancelled Aug 5, 1983 · Built 1952 · Dhl Corp N8159QCessna 402B · S/N 402B0375Cancelled Apr 13, 1981 · Zellers Harry A N49120Taylorcraft DCO-65 · S/N 5265Cancelled Oct 15, 1974 · Skyline College N8042BCessna 172 · S/N 29842Cancelled Aug 12, 1974 · Hammer Irwin M N86105Cessna 337D · S/N 3371082Cancelled Jan 3, 1973 · Exported to Canada · Leasemobile N36079Taylorcraft BC12-65 · S/N 3046Cancelled Jan 3, 1972 · Built 1941 · Latta Lyman C N49697Fairchild PT-26 · S/N T43-4488Cancelled Jan 4, 1971 · Brown Joe L And Don B Gordon N9369KUniversal Stinson 108-2 · S/N 108-2369Cancelled May 21, 1965 · R S Kramer N41709Culver LFA · S/N 418Cancelled Oct 21, 1955 · Barrier Barton R N18788Beech E17B · S/N 213Cancelled Jun 1, 1940 · Built 1938 · Mouton And Clyde Inc N12707Mattley Airplane & Motor F P 2 · S/N 7Cancelled Mar 8, 1939 · Built 1932 · Bay Shore Flying Club/ C/O Fred Beltramo N23NMattley Airplane & Motor MATTLEY GLIDER · S/N 1Cancelled Apr 1, 1935 · Mattley Airplane & Motor Co Inc N10615Mattley Airplane & Motor Co IN MATTLEY FLIVER · S/N 6Cancelled Feb 19, 1934 · Mattley Airplane & Motor Co Inc N789VBrewster FLEET 7 · S/N 370Cancelled Sep 25, 1933 · Summit Flying Schools Ltd N2910Waterhouse William ROAMAIR · S/N 17Cancelled Nov 30, 1928 · Zieglitz Arthur H N67269Cessna UC-78 · S/N 5493Cancellation date not recorded · Warner W

Back to San Bruno, CA