Magnolia, TX
Cancelled registrations · 41
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 = 'TX' AND d.registrant_city = 'MAGNOLIA' 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 = 'TX' AND d.registrant_city = 'MAGNOLIA' 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.
N21634Cessna 150L · S/N 15074549N24CTPiper PA-34-200T · S/N 34-7670248N740FTPiper PA-44-180 · S/N 44-7995084N2141XCessna 337 · S/N 337-0041N25VCRockwell International NA-265-65 · S/N 465-15N626CGBritish Aerospace BAE 125 SERIES 800A · S/N 258041N8596MBeech P35 · S/N D-7234N815WBBohannon James A JR JAB-08 · S/N AC4328N107DPFreefly Systems ALTA · S/N 211454N132ARDJI Innovations PHANTOM 3 PROFESSION · S/N P76DCF17017363N237TXAscending Technologies ASCTEC FALCON 8 · S/N 31121N729BDDJI MATRICE 100 · S/N M020DJ09020015N729EPFreefly Systems ALTA · S/N 750826N729ZPFreefly Systems ALTA · S/N 816991N730AJFreefly Systems ALTA · S/N 639605N8974YPiper PA-39 · S/N 39-140N235TXAscending Technologies ASCTEC FALCON 8 · S/N 30350N236TXAscending Technologies ASCTEC FALCON 8 · S/N 30280N105MGGibson Mark R MAKO 15B · S/N MAKO15B-2015N510VGMark Gibson MAKO 15 · S/N MAKO15-2014N264DJAmerican Champion 8KCAB · S/N 823-98N1033LWimp Ivan G MIDGET MUSTANG MM-1 · S/N 767N518GTIsrael Aircraft Industries 1124 · S/N 190N550ESChaplin D E/Chaplin M J LANCAIR ES · S/N ES-098N927DLAmerican AA-1 · S/N AA1-0292N992FHFairchild M-62C(PT-23A) · S/N T43-4341N713TXJason Knight ARROWCOPTER AC20 · S/N 039N9726CHelton LARK 95 · S/N 9501N86655Lark 95 · S/N 9504N7106Rohsner EPB-1C · S/N R-1N14RJJohannsen Rodney C SONERAI II · S/N 745N67DTIsrael Aircraft Industries 1124A · S/N 364N22407Cessna 150H · S/N 15068261N3923PPiper PA-22-150 · S/N 22-3596N3673YCessna 210C · S/N 21058173N44423Kordic John E MX II · S/N 60092N28BEBell 206B · S/N 3922N4224CCessna T206H · S/N T20608276N5673VPiper PA-28-161 · S/N 28-7716196N573RSSpeck Robert CAVALIER-RS · S/N GF5573N6210MStinson 108-3 · S/N 108-4210
Back to Magnolia, TX