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 = 'CA' AND d.registrant_city = 'STUDIO CITY' 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 = 'STUDIO CITY'
  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 = 'STUDIO CITY'
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.

N7850KJabiru USA Sport J250-SP · S/N 389Cancelled Oct 3, 2022 · First renewal notice · Built 2007 · Peace David W N800GCDiamond Aircraft Industries HK 36 TTC · S/N 36.616Cancelled Apr 29, 2019 · Exported to Japan · Built 1998 · Ifly La LLC N761SSCessna A152 · S/N A1520983Cancelled Sep 20, 2017 · Exported to Brazil · Built 1981 · Pilot Solutions N93236Commonwealth REARWIN 185 · S/N 1741Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1946 · Poston Richard D N7838PPiper PA-24-250 · S/N 24-3059Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1962 · Brunelle Roger P N3667GBalloon Works FIREFLY 7 · S/N F7-082Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Barlia David L N780DCross SCORPION S1 CD-1 · S/N RWS3Cancelled Feb 28, 2013 · Sale reported, canceled · Built 1972 N25732Piper PA-38-112 · S/N 38-81A0066Cancelled Sep 17, 2012 · Registration expired, pending cancellation · Built 1981 · Park David P N8171GPiper PA-32R-301T · S/N 32R8029052Cancelled Jan 30, 1997 · Triennial form not returned · Nassif Christopher S N46JWCessna 210 · S/N 57552Cancelled Oct 16, 1992 · Triennial form not returned · R L G And Co N88RGPiper PA-31-310 · S/N 31-667Cancelled Jan 31, 1989 · Registration expired, pending cancellation · Built 1970 · Rich Greg DBA N24257Cessna 152 · S/N 15280177Cancelled May 1, 1981 · Built 1977 · Mitchell George Et Al N92813Sikorsky S-51 · S/N 5139Cancelled Oct 30, 1975 · Belinn Clarence M N68790Lockheed 382B · S/N 3990Cancelled Oct 16, 1974 · Pacific Air And Sea Suppliers N76694Lockheed 382B · S/N 3991Cancelled Oct 16, 1974 · Pacific Air And Sea Suppliers N7651GCessna 172L · S/N 17259351Cancelled Jan 25, 1974 · Rosett Richard L N5312EBeech K35 · S/N D5814Cancelled Nov 15, 1972 · Food Services Interior Co Russell Weinstein Owner N7793SSchweizer SGS 1-26D · S/N 462Cancelled May 5, 1972 · Built 1969 · Molinari Eric N195BDCessna 195 · S/N 7384Cancelled Feb 23, 1972 · Bob Dawn & Associates N1793BDouglas DC3 · S/N 4859Cancelled Jun 30, 1970 · Built 1944 · Aviation Finance N92854Curtiss Wright C-46A · S/N 250Cancelled Jun 30, 1970 · Aviation Finance N323ADouglas DC-7 · S/N 44144Cancelled Nov 30, 1966 · Exported to Denmark · Allen E Paulson N67933Curtiss Wright C-46F · S/N 2489Cancelled Jan 6, 1964 · Aviation Finance Inc N4761CCurtiss Wright C-46D · S/N 30465Cancelled Apr 7, 1960 · Exported to Colombia · Aviation Finance N88719Noorduyn UC-64A · S/N 365Cancelled Oct 17, 1951 · Exported to Canada · Knight E P N58089Cessna T-50 · S/N 2230Cancellation date not recorded · Exported to Canada · Built 1941 · Robert Kashower C/O Gordon Buck

Back to Studio City, CA