Birmingham, AL
Cancelled registrations · 305
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 = 'BIRMINGHAM' 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 = 'BIRMINGHAM' 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.
N3025VBeech 35 · S/N D-429N51CJGrimes Charles J BD-5B · S/N 2185N14RHHayes PITTS S1C · S/N RMH1N8090RBeech D55 · S/N TE-727N68PKPilatus PC-12/45 · S/N 265N54196Fairchild M-62A · S/N T437048N1389CPiper PA-18A-135 · S/N 18-2651N125DCGrumman G-1159 · S/N 55N723EACirrus Design SR22 · S/N 1512N2416WSchweizer SGS 1-26C · S/N 364N662TBDJI PHANTOM 2 VISION + · S/N PH645319681 V2.0N39696Piper PA-32RT-300T · S/N 32R-7887147N131JGAero Commander 680 · S/N 680-515-185N7689ZPiper PA-25-235 · S/N 25-3846N6388KRepublic RC-3 · S/N 617N1615MBoeing E75 · S/N 75-8410N6SZSzybowcowy Zaklad Doswiadczaln SZD-36-A · S/N W813N510BCMitsubishi MU-300 · S/N A057 S.A.N904ACFokker D-VII · S/N 03N700RJSmith AEROSTAR 601P · S/N 61P-0288-068N17799Aeronca K · S/N K-66N3051DCessna 310 · S/N 35251N3580SCessna 172E · S/N 17250780N14VYBeech A45 · S/N BG-74N1065HAeronca 15AC · S/N 15AC-83N56588Laister-Kauffman LK-10A · S/N 71N111JBBrantley Junius STARDUSTER-I · S/N JB-01N2699CCessna 310 · S/N 35099N7540WPiper PA-28-180 · S/N 28-1473N122STAero Commander 1121B · S/N 122N7246VIntermountain CALLAIR A-9 · S/N 1283N101EZFrierson VARIEZE · S/N 1182N937PJBrophy John W GLASTAR · S/N 5760N41712Culver LCA · S/N 419N7XLLund Bruce R MUSTANG-II · S/N M-II-707N532XCrews Ken AIR COMMAND 532 · S/N 091986N14529Tullis KR-2 · S/N 220N1517CRochester DAVIS DA-2A · S/N 37N2788YBeech 95 · S/N TD-170N7363ZPiper PA-25-235 · S/N 25-3316N98316Piper PA-28-140 · S/N 28-26166N511RMReynolds Robert F CHALLENGER 1 SPECIAL · S/N 1098-CW-0703N91368Grumman S2F-1 (TS-2A) · S/N 136560N75GHHarrison MINI MAC · S/N 3N7574CForney F-1 · S/N 5691N76872Cessna 120 · S/N 11306N734ZPCessna 172N · S/N 17269247N188DCGrumman American Avn. G-1159 · S/N 188N4719VBellanca 17-30 · S/N 30059N14TACessna 210B · S/N 21058007
Back to Birmingham, AL