Ormond Beach, FL
Cancelled registrations · 80
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 = 'FL' AND d.registrant_city = 'ORMOND BEACH' 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 = 'FL' AND d.registrant_city = 'ORMOND BEACH' 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.
N9602UGrumman American Avn. AA-5 · S/N AA5-0802N510XPiper PA-28-161 · S/N 28-8616013N997SPScoda Aeronautica Ltda SUPER PETREL LS · S/N S0394N243TTPiper PA-28-161 · S/N 2842053N567WPPiper PA-22-150 · S/N 22-7126N232AMcmanus William R ZENITH 601XL · S/N 6-5731N651JGApplied Aeronautics ALBATROSS MAX UAV · S/N 044N4176CStinson 108-3 · S/N 108-5176N8263SPiper PA-28-140 · S/N 28-26838N500YCCoutisson Ynes MINI 500 · S/N 0430N3485PPiper PA-23-160 · S/N 23-1459N1330ZBeech N35 · S/N D-6768N733SCCessna 172N · S/N 17268505N614TASchweizer 269C-1 · S/N 0080N8781Bensen Gyrocopter B8 · S/N 13582N5293YPiper PA-23-250 · S/N 27-2358N340MMCessna 340A · S/N 340A0635N89557Cessna 152 · S/N 15282785N5792Cornell BENSEN B-8M · S/N 1N6942LCessna 310K · S/N 310K0042N707JKKlien John L MA-5 · S/N EX01N526JHSchweizer 269C-1 · S/N 0175N133TASchweizer 269C-1 · S/N 0348N21AECessna 340 · S/N 340-0339N952SACessna 152 · S/N 15280667N59BWBeech B19 · S/N MB-508N215SAPiper PA-28-161 · S/N 28-7716298N6062KCessna 150M · S/N 15077503N704KKCessna 150M · S/N 15078670N9202CPiper PA-28-161 · S/N 2841002N757VTCessna 152 · S/N 15280044N65436Cessna 152 · S/N 15281551N704ZFCessna 150M · S/N 15078997N761ZDouglas DC-7B · S/N 45403N6953VMooney M20C · S/N 20-1186N3410QCessna 320E · S/N 320E-0010N204EPiper PA-44-180 · S/N 44-7995313N347JMMaule M-7-260C · S/N 30011CN886ZBensen B-8 · S/N S-1N160TACessna 182R · S/N 18268209N44930Piper PA-28-161 · S/N 28-7816045N24913Cessna 152 · S/N 15280447N520PRRichmond Paul/Mary ROTORWAY EXEC · S/N PR5013312938MJN90985Bellanca 7KCAB · S/N 345-73N8678VBellanca 7GCBC · S/N 827-75N39339Lynch Joseph P STARDUSTER TOO SA300 · S/N 1N704XQCessna 150M · S/N 15078959N6237KCessna 150M · S/N 15077603N63591Cessna 150M · S/N 15077414N47806Piper PA-28R-201T · S/N 28R-7803017
Back to Ormond Beach, FL