Lafayette, LA
Cancelled registrations · 540
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 = 'LAFAYETTE' 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 = 'LAFAYETTE' 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.
N18GJLearjet 45 · S/N 442N491PHBell 407 · S/N 53386N714PSikorsky S-76C · S/N 760719N4001PPiper PA-23-160 · S/N 23-1476N3237DCessna 180 · S/N 32035N9271PPiper PA-24-260 · S/N 24-4771N5753BBell Helicopter Textron 206L-1 · S/N 45514N9038NAero Commander 500 S · S/N 3050N395PAmerican Eurocopter AS350B3 · S/N 7698N7643PPiper PA-24 · S/N 24-2857N5435VSikorsky S-76 · S/N 760158N8222QCessna 414 · S/N 414-0152N49XBRobinson Helicopter R66 · S/N 0671N42CVPiper PA-31T · S/N 31T-8020067N257FPiper PA-23-250 · S/N 27-2330N947PHSikorsky S-92A · S/N 920256N236KMPiper PA-46-310P · S/N 46-8508014N110AEDJI MATRICE 600 PRO · S/N DL071347220482N487PHBell Helicopter Textron Canada 412EP · S/N 36668N488PHBell Helicopter Textron Canada 412EP · S/N 36669N294ABPiper PA-34-220T · S/N 34-8133257N148PHAgustawestland Philadelphia AW139 · S/N 41300N5736JBell 212 · S/N 31140N3208HBell 212 · S/N 31304N911TLMesserschmitt-Bolkow-Blohm BK 117 B-2 · S/N 7198N6585DDJI INSPIRE 1 · S/N W13DCA23020289N683NSDJI INSPIRE 1 · S/N W13DCA23020236N94LADJI PHANTOM 3 PROFESSION · S/N CF271332426502N16MZMozi Robotics QUADTHRUST 350 · S/N MR00010615N851BABlade BLH 8665 · S/N 00E05C411A4CN570WSSmith Mark EVANS VP-1 · S/N MXS 5-2-06N562PNDJI PHANTOM 2 VISION + · S/N PH645488148N33FACessna 421B · S/N 421B0502N796PSikorsky S-76C-2 · S/N 760681N18719Cessna 150L · S/N 15074059N770PHSikorsky S-76A · S/N 760231N3896WBell 206B · S/N 3197N786PSikorsky S-76C · S/N 760643N784PSikorsky S-76C · S/N 760634N911EBMesserschmitt-Boelkow-Blohm BO-105S · S/N S-812N911WKMesserschmitt BO105CBS · S/N S-753N926RHSikorsky S-92A · S/N 920121N790PSikorsky S-76C · S/N 760675N7200DPiper PA-22-150 · S/N 22-5024N90FVMyers David SONERAI I · S/N 217N91074Piper PA-28-161 · S/N 28-8616005N940PSikorsky S-92A · S/N 920073N480PHBell Helicopter Textron Canada 412EP · S/N 36589N158LWBeech 58P · S/N TJ-381N481PHBell Helicopter Textron Canada 412EP · S/N 36596
Back to Lafayette, LA