Skip to content

Baton Rouge, LA

Cancelled registrations · 253

Query with SQL

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 = 'BATON ROUGE' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'BATON ROUGE'
  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 = 'BATON ROUGE'
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.

N2782VBeech 35 · S/N D-174Cancelled Apr 14, 2025 · Registration pending, canceled · Built 1947 N521DFDJI INSPIRE ONE · S/N WJ13J1A002G007Cancelled May 8, 2024 · Led Fast Start N3924SCessna 172E · S/N 17251124Cancelled Sep 30, 2023 · Revoked, canceled · Built 1963 · Hef Flyers N70756Piper J3C-65 · S/N 17773Cancelled Jul 10, 2023 · Built 1946 · Hart Clarence M N722PZJohn W Couvillon HIGH-MAX 1700R · S/N 121939Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Couvillon John W N150ASBell Helicopter Textron Canada 407 · S/N 54658Cancelled Feb 7, 2023 · Rc Smith Aviation LLC N827MGDJI INSPIRE 1 V2 · S/N FD1619585S8522Cancelled Feb 4, 2023 · Registration expired, pending cancellation · East Baton Rouge Parish Sheriffs Office N7787LDJI PHANTOM 2 VISION + · S/N PH645428894Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Office Of Louisiana State Fire Marshal N759MPDJI PHANTOM 4 · S/N 07DDD4C0A10487Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Command Cam Productions LLC N597ESPrecision Drone PACESETTER · S/N DA000144Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Lsu Agcenter N327BKSmith AEROSTAR 601 · S/N 61-0145-076Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1973 · Knight Robert T Sr N92PPSimpson Jay M KITFOX III · S/N 1137Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1991 · Chidester Arthur Daniel N521FSDJI INSPIRE 1 · S/N W13DCA12020881Cancelled May 25, 2021 · Louisiana Economic Development Fast Start N2546BColumbia Aircraft Mfg LC41-550FG · S/N 41582Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 2006 · Reitz Offshore Logistics LLC N4708Grumman Acft ENG Cor-Schweizer G-164A · S/N 1088Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1973 · Weber Donald R N579SPBell OH-58A · S/N 70-15309Cancelled Jul 10, 2020 · Registration expired, pending cancellation · East Baton Rouge Parish Sheriff N19714Aeronca K · S/N K235Cancelled Jun 5, 2020 · Revoked, canceled · Built 1937 · Rushing Sam C N789YBDJI INSPIRE 1 · S/N W13DDC10061246Cancelled Feb 28, 2020 · Registration expired, pending cancellation · East Baton Rouge Parish Sheriffs Office N61242Westerman Rhett GLASTAR · S/N 001Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Built 1998 · Westerman Rhett J N4656HPiper PA-17 · S/N 17-64Cancelled Jan 16, 2020 · Revoked, pending cancellation · Built 1948 · Smith F B N5251MTaylorcraft BC12-D · S/N 10551Cancelled Dec 10, 2019 · Revoked, pending cancellation · Built 1947 · Ryan Ronald N754LUDJI PHANTOM 2 VISION + · S/N PH646028214Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Mapp Construction LLC N1549BLuscombe 8A · S/N 6176Cancelled Oct 18, 2019 · Revoked, canceled · Built 1948 · Bienn Gerald N749LCDJI PHANTOM 2 · S/N 645723891Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Command Cam Productions LLC N39245Cinestar 6HL · S/N QC-20032-2Cancelled Oct 4, 2019 · Registration expired, pending cancellation · Command Cam Productions LLC N5010DSloan James L CHINOOK WT 11 · S/N 01827Cancelled Sep 13, 2019 · Sale reported, pending cancellation · Built 1984 N1628XSchweizer 269C-1 · S/N 0258Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2006 · Louisiana Community And Technical College System N39281DJI PHANTOM 2 · S/N 645223891Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Command Cam Productions LLC N50168Fairchild M-62A · S/N T41538Cancelled Sep 6, 2019 · Revoked, canceled · Built 1941 · Harris James T N71205Luscombe 8A · S/N 2632Cancelled Aug 5, 2019 · Revoked, canceled · Built 1946 · Pelican State Flying Club N20938Schweizer 269C-1 · S/N 0186Cancelled Jul 16, 2019 · Registration expired, pending cancellation · Built 2004 · Louisiana Community And Technical College System N217GCDJI PHANTOM 2 · S/N PH636146815Cancelled Feb 23, 2019 · Registration expired, pending cancellation · Gulf Coast Unmanned Aerial Services LLC N356SPBell OH-58A · S/N 72-21408Cancelled Feb 21, 2019 · First renewal notice · Louisiana Department Of Public Safety N558SPBell OH-58A · S/N 71-20631Cancelled Jan 22, 2019 · Registration expired, pending cancellation · East Baton Rouge Parish Sheriff N9483XCessna 210A · S/N 21057783Cancelled Jan 15, 2019 · Revoked, canceled · Built 1961 · Daves Arcft Inc N7066JNorth American/Weber T-28C · S/N 1Cancelled Dec 17, 2018 · Registration expired, pending cancellation · Built 1951 · Weber Donald R N319CCole STARDUSTER TOO · S/N 1091Cancelled Sep 28, 2018 · Sale reported · Built 1910 N4399KRyan NAVION A · S/N NAV-4-1399Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1948 · Downs L Ray N7492SButler AEROSTAR 601 · S/N 61-0055-104Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Built 1970 · Knight Robert T Sr N1983DBeech C35 · S/N D-3205Cancelled May 30, 2018 · Sale reported, canceled · Built 1952 N22267Piper PA-32RT-300T · S/N 32R-7887252Cancelled May 30, 2018 · Sale reported, canceled · Built 1978 N2942NCessna 120 · S/N 13203Cancelled May 3, 2018 · Registration expired, pending cancellation · Built 1947 · Graham Aviation LLC N96398Mooney M20K · S/N 25-0531Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1981 · Mooney LLC N40416Vincent Kent R KING COBRA · S/N K122002Cancelled Mar 23, 2018 · Registration expired, pending cancellation · Built 1983 · Garrett Richard T N38392Piper PA-28-161 · S/N 28-7716249Cancelled Mar 16, 2018 · Revoked, canceled · Sky Ward Acft Lsg Inc N22125Cessna 150H · S/N 15068076Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1967 · W & L Hill LLC N1344JRockwell International 112A · S/N 344Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Built 1975 · Quest Aviation LLC N25360Balloon Works FIREFLY 7B-15 · S/N F7B-328Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1992 · Albaugh Deanna K N3046XCessna 150F · S/N 15064446Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1966 N678BFFortney Bill G PREDATOR · S/N PC020752W402Cancelled Feb 15, 2018 · Sale reported, canceled · Built 2008

Back to Baton Rouge, LA