Tuscaloosa, AL
Cancelled registrations · 60
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 = 'TUSCALOOSA' 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 = 'TUSCALOOSA' 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.
N704HACessna 150M · S/N 15078613N63PDBell OH-58C · S/N 71-20594N690BBBeech B90 · S/N LJ-415N528DSCessna 501 · S/N 5010206N815ALDJI PHANTOM 3 PROFESSION · S/N P76DCD18010444N421EPCessna 421C · S/N 421C1236N49LKKinsey Larry R VARIEZ 0-235 · S/N 376N186CCHaynes Charles D VANS RV 4 · S/N CH-01N801EBAero Commander 690A · S/N 11111N3076BHead Balloons AX8-88 · S/N 280N63PHBell OH-58C · S/N 69-16256N153GPBell OH-58A · S/N 70-15611N954DSSmith David CHALLENGER II · S/N 1490N7642MCessna 175 · S/N 55942N26727Piper J4A · S/N 4-875N8831FPiper PA-32-300 · S/N 32-7740025N70003Head Balloons AX7-77 · S/N 132N308REHorton Gary ROTEC RALLY 3B · S/N 33N215XPRockwell International 114A · S/N 14525N9016AAdams Balloon A50S · S/N 016N9052TCessna 182C · S/N 52952N5681LAmerican AA-1 · S/N AA1-0081N7291VAero Commander CALLAIR A-9 · S/N 1327N2018KTerry Don MURPHY RENEGADE · S/N 0200N15ABBrown CASSUTT 111 M · S/N ACB-3N29291Culver LCA · S/N 160N377CBMinges Billy QCKSLVR SPRNT MX II · S/N 0579N301JWBeech B300 · S/N FL-13N6165TUniversity Ala FLT Dynmics Lab MINI 500 · S/N 311N9119CCessna R182 · S/N R18200410N43PBDouglas DC-3A-S1C3G · S/N 1953N9219RCessna A188B · S/N 18802163TN737VYCessna 172N · S/N 17269720N700CHCessna 172N · S/N 17271270N711FSBeech 65 · S/N LC139N8876UCessna 150M · S/N 15078010N7113NBeech D55 · S/N TE-508N6877DCessna 402C · S/N 402C-0527N738AUCessna 172N · S/N 17269832N8210QCessna 402B · S/N 402B0390N26592Cessna 421C · S/N 421C0846N9189SBeech C23 · S/N M-1804N7DSCessna A188A · S/N 18800805N6088TCessna 150E · S/N 150-60788N38985Fairchild M-62A · S/N T42-1959N33065Piper J5A · S/N 5-441N92295Piper J3C-65 · S/N 16868N8977ZCessna 310G · S/N 310G0077N27118Piper J3C-65 · S/N 4381N7206ECessna 182 · S/N 52206
Back to Tuscaloosa, AL