White Plains, NY
Cancelled registrations · 102
Query with SQL
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 = 'NY' AND d.registrant_city = 'WHITE PLAINS' 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 = 'NY' AND d.registrant_city = 'WHITE PLAINS' 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.
N780PSikorsky S-76D · S/N 761030N151JEIsrael Aircraft Industries GULFSTREAM 200 · S/N 152N8361YAeryon Labs SKY RANGER · S/N SR9161671N836YNAeryon Labs SKY RANGER · S/N SR2162472N836ZDAeryon Labs SKY RANGER · S/N SR8160627N837DPAeryon Labs SKY RANGER · S/N SR2164656N3636RPiper PA-28-180 · S/N 28-5731N8777MBeech A23 · S/N M-562N8124HHiller UH-12 · S/N 124N587AAMcdonnell Douglas DC-9-82(MD-82) · S/N 53250N74ZDouglas DC3C 1830-94 · S/N 25953N802JAWings Aloft SEAREY · S/N 1MK257N8112HHiller UH-12 · S/N 112N188DDRobinson Helicopter R44 II · S/N 11314N28239Socata TAMPICO TB 9C · S/N 1152N8500North American NA-265-40 · S/N 282-108N100HFGulfstream Aerospace G-IV · S/N 1338N5382RCessna 172F · S/N 17252917N40293Piper PA-23-250 · S/N 27-7305108N74053Nagler Helicopter NAGLER HELICOPTER · S/N 2N127CCasale STITS SA6-B · S/N P2065N38DMSchweizer 269C · S/N S1458N5012SPiper PA-28R-200 · S/N 28R-35739N500PCCanadair CL-600-2B16 · S/N 5071N697DADiamond Aircraft Ind DA20-A1 · S/N 10219N734CDCessna 172N · S/N 17268742N8540QCessna TU206F · S/N U20603396N7GABeech A100 · S/N B119N6155JPiper PA-32-260 · S/N 327600017N374GCanadair CL-600-2A12 · S/N 3015N58CVBeech 58 · S/N TH1226N552FLPiper PA-28-140 · S/N 287125390N277SWZill EXPLORER · S/N 007N632SQCessna 500 · S/N 500-0344N600CBBeech 100 · S/N B-36N418LABeech 100 · S/N B-61N9PNMitsubishi MU-2B-20 · S/N 222N74KABeech A100 · S/N B-197N79876Cessna 172K · S/N 17258211N1ANMitsubishi MU-2B-10 · S/N 109N622RDassault/Sud MYSTERE FALCON 20 · S/N 86N9993RBeech B95 · S/N TD-427N42QFairchild F-27A · S/N 66N7489RPiper PA-28-140 · S/N 28-22043N337NHCessna 337D · S/N 3371080N4194LCessna 172G · S/N 172-54263N239PSwearingen SA-26AT · S/N T26-147N82008Aeronca 7AC · S/N 7AC-633N82679Aeronca 7AC · S/N 1321N84625Aeronca 7AC · S/N 7AC-3332
Back to White Plains, NY