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.
N486PHBell Helicopter Textron Canada 412EP · S/N 36601N746PBSikorsky S-76C · S/N 760623N779PDSikorsky S-76C · S/N 760655N211KFBins Tom KITFOX IV · S/N 1496N32041Bell 206L-3 · S/N 51539N36ZAZenair CH 2000 · S/N 200036N761PHSikorsky S-76A · S/N 760224N145PEAgustawestland Philadelphia AW139 · S/N 41271N763PSikorsky S-76A · S/N 760166N764PSikorsky S-76A · S/N 760276N762PSikorsky S-76A · S/N 760060N1546KSikorsky S-76A · S/N 760082N1545KSikorsky S-76A · S/N 760047N480RABell Helicopter Textron 206L-1 · S/N 45401N369TSHawker Siddeley HS-125-600A · S/N 256069N692RSikorsky S-92A · S/N 920028N30531Fawvor James Kim FLIGHTSTAR II SL · S/N 273N114EZCarter Ward VERIEZ · S/N N114EZN892HSikorsky S-92A · S/N 920038N3458KPiper PA-28-140 · S/N 28-23565N792HSikorsky S-92A · S/N 920037N434WWBell 222 · S/N 47019N923HSikorsky S-92A · S/N 920104N924RSikorsky S-92A · S/N 920116N206DDBell Helicopter Textron 206L-1 · S/N 45242N22347Bell 412 · S/N 36005N1545XSikorsky S-76A · S/N 760050N1546GSikorsky S-76A · S/N 760076N760PHSikorsky S-76A · S/N 760078N776PSikorsky S-76A · S/N 760275N229RHBell 206L-3 · S/N 51184N209RHBell 206L-3 · S/N 51531N10311Snyder & Owsley MONERAI-S · S/N 81N7897XBell 206-L4 · S/N 52297N416PHBell 407 · S/N 53276N484PHBell Helicopter Textron Canada 412EP · S/N 36599N483PHBell Helicopter Textron Canada 412EP · S/N 36598N485PHBell Helicopter Textron Canada 412EP · S/N 36600N992RHSikorsky S-92A · S/N 920055N3982MCameron Balloons US V-90 · S/N 5668N13CSSimmons Chris S SONERAI II · S/N 1175N6992Bell 222U · S/N 47521N393AABell 230 · S/N 23028N65734Boeing A75N1(PT17) · S/N 75-769N5814MCessna 310P · S/N 310P0114N4606HPiper PA-17 · S/N 17-22N8765JMesserschmitt-Bolkow-Blohm BK 117 A-4 · S/N 7054N27497Taylorcraft BC-65 · S/N 2139N2008CBeech C23 · S/N M-2059N266PBell 206-L4 · S/N 52271
Back to Lafayette, LA