New Iberia, LA
Cancelled registrations · 187
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 = 'LA' AND d.registrant_city = 'NEW IBERIA' 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 = 'LA' AND d.registrant_city = 'NEW IBERIA' 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.
N291BGSikorsky S-92A · S/N 920126N239BGAgusta Aerospace AW139 · S/N 41221N763BGKeystone Helicopter S-76C · S/N 760774N890BGSikorsky S-76C · S/N 760645N431ALBell Helicopter Textron Canada 407 · S/N 53923N45003Sikorsky S-76C · S/N 760654N617ALBell 407 · S/N 53265N687ALBell 407 · S/N 53366N821VWSikorsky S-76C · S/N 760718N894BGSikorsky S-76C · S/N 760615N897BGSikorsky S-76C · S/N 760664N7650GSikorsky S-76D · S/N 761050N7653HSikorsky S-76D · S/N 761053N577ALBell 407 · S/N 53247N7667RSikorsky S-76D · S/N 761067N460WBBell Helicopter Textron Canada 412EP · S/N 36588N16665Badeaux Oran P CHALLENGER II · S/N ORAN01N68025Hiller UH-12D · S/N 58-5438N1DYCessna 310C · S/N 39020N830QABell 412EP · S/N 36354N7646LSikorsky S-76D · S/N 761046N72372Cessna 120 · S/N 9558N792BGSikorsky S-92A · S/N 920282N7644ESikorsky S-76D · S/N 761044N7645TSikorsky S-76D · S/N 761045N7670ESikorsky S-76D · S/N 761070N7671NSikorsky S-76D · S/N 761071N259CVSikorsky S-92A · S/N 920259N254JSikorsky S-92A · S/N 920254N262USikorsky S-92A · S/N 920262N257ZSikorsky S-92A · S/N 920257N7007QBell 412EP · S/N 36315N406ALBell 407 · S/N 53481N5500NQuicksilver GT-500 · S/N GT5 TC0101N97067Murrayair MA-1 · S/N 011N242FSikorsky S-92A · S/N 920242N29MTPiper PA-22-160 · S/N 22-6984N240ESikorsky S-92A · S/N 920240N492SHAgustawestland Philadelphia AW139 · S/N 41374N228VSikorsky S-92A · S/N 920228N487SHAgustawestland Philadelphia AW139 · S/N 41368N485SHAgustawestland Philadelphia AW139 · S/N 41363N213BSSikorsky S-92A · S/N 920213N330PBell 206L-3 · S/N 51295N93473Engineering & Research 415-C · S/N 796N200BVSikorsky S-92A · S/N 920200N61202Quicksilver MXL II · S/N MXL II SPORT 000870N197YSikorsky S-92A · S/N 920197N61532Boeing A75L3 · S/N 75-1383N433SHAgustawestland Philadelphia AW139 · S/N 41339
Back to New Iberia, LA