Ozark, AL
Cancelled registrations · 114
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 = 'AL' AND d.registrant_city = 'OZARK' 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 = 'AL' AND d.registrant_city = 'OZARK' 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.
N6846QGrumman Acft ENG Cor-Schweizer G-164A · S/N 1722N24722Cessna 152 · S/N 15280338N1198WBell 47G-4 · S/N 2952N1038YHughes 269A · S/N 660583/64-18227N405ASBell UH-1H · S/N 64-13629N42321Bell UH-1H · S/N 7016289N980ASBell UH-1H · S/N 6509663N10HDBell TH-13T · S/N 67-17030N700UHBell/Southern Aero UH-1H · S/N 65-9703N25UHBell 212 · S/N 30818N22UHU S Helicopter UH-1H · S/N 7016299N21UHU S Helicopter UH-1H · S/N 7321679N16UHBell UH-1H · S/N 6815554N17UHBell UH-1H · S/N 6717762N19UHBell UH-1H · S/N 6600789N15UHBell UH-1H · S/N 6601097N9181FHughes 369HS · S/N 340571SN11UHBell UH-1H · S/N 7015871N205UDBell UH-1H · S/N 6600915N205UEBell UH-1H · S/N 6616606N82814Bell UH-1H · S/N 6601156N8281BBell UH-1H · S/N 6600837N6190PBell UH-1H · S/N 6616027N6204DBell UH-1E · S/N 154757N1026SHughes TH-55 · S/N 6418156N213Camair 480 · S/N 1057N3126BBeech E50 · S/N 563718N3126GBeech E50 · S/N 573097N49235Dehavilland DHC-2 · S/N 211N5579AHughes TH-55 · S/N 6418220N5579KHughes TH-55 · S/N 6618338N6NFLearjet 25 · S/N 021N800NEAero Commander 560-A · S/N 267N87765Bell UH-1B · S/N 622096N8894HNorth American NAVION · S/N NAV4894N9049JHughes 269A · S/N 6418033N9049KHughes TH-55 · S/N 6410868N9189RBeech C18S · S/N 6808N95576Bell TH-13T · S/N 6717034N95577Bell TH-13T · S/N 6717084N95578Bell TH-13T · S/N 6717123N39SBStockwell/Booth SB-1 · S/N 851N6020ZPiper PA-25 · S/N 2524N9032HSwearingen SA26-T · S/N T267N205TEBell 205A-1 · S/N 30292N6055ZPiper PA-25 · S/N 2562N64675Cessna O-2A · S/N 6811013N2303VDehavilland CARIBOU DHC-4A · S/N 107N709WAHiller UH-23-C · S/N IA-HH-68-01N2271VAgusta Bell AB205 · S/N 4090
Back to Ozark, AL