Lexington, KY
Cancelled registrations · 166
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 = 'KY' AND d.registrant_city = 'LEXINGTON' 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 = 'KY' AND d.registrant_city = 'LEXINGTON' 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.
N5173WPiper PA-28-150 · S/N 28-204N7611ACessna A152 · S/N A1520739N176EMRoth SONERAI II · S/N 307N7635YPiper PA-30 · S/N 30-713N629DSDiamond Aircraft Ind DA 40 · S/N 40.629N1956XBourgois Louis G III WAG AERO SUPER SPORT · S/N 3685N672QUDJI INSPIRE 1 · S/N W13DCH19041407N688GPDJI PHANTOM 2 · S/N PH6 4602 7013N688TSDJI PHANTOM 3 PROFESSION · S/N P76DCD13012467N512LBLindstrand Balloons 90A · S/N 5035N106GSocata TB 10 · S/N 596N6203FCessna 172N · S/N 17273164N751LUPiper PA-28R-201 · S/N 2844146N521MAPiper PA-28-181 · S/N 2843221N678GPMitchum James E JR HIGH COMMAND · S/N MAC001N330PAPiper PA-28-181 · S/N 2843513N2814TPiper PA-28-180 · S/N 28-7205226N773RSDJI PHANTOM 2 VISION + · S/N PH646039691N3154JNew Piper PA46-350P · S/N 4636388N859ZHSkywalker Technologies SKYWALKER X8 · S/N BC5BN82794Aeronca 7AC · S/N 7AC-1441N859ZGSkywalker Technologies SKYWALKER X8 · S/N BC5AN859ZA3D Robotics X8 · S/N UKY1N859ZFDJI S1000+ · S/N UKY2N12112DJI INSPIRE 1 · S/N W130CC23020387N641AMYuneec International TYPHOON Q500 4K · S/N YU15261502B04B01N598DHEvent 38 Unmanned Systems E384 · S/N 3845041N608BE3D Robotics X8+ · S/N 00330038 30345101 37383933N608HE3D Robotics AERO · S/N 00370044 30345108 37383933N608JE3D Robotics X8 · S/N 001A0029 34324708 31323533N620BE3D Robotics X8+ · S/N 00270029 35324707 36343032N620DV3D Robotics X8+ · S/N 003B0032 33334709 36303030N620GE3D Robotics X8+ · S/N 001F0020 35324707 36343032N621AV3D Robotics X8+ · S/N 003D0026 31334705 39343031N4259Aerochute Australia AEROCHUTE · S/N 249N94724Buckeye Industries DREAM MACHINE · S/N 4564N244PDRobinson Helicopter R44 · S/N 0592N3348APiper PA-22-135 · S/N 22-1623N565UTCameron Balloons US N-90 · S/N 6161N105TSThunder & Colt AX8 105SII · S/N 2322N4058KCameron Balloons US A-105 · S/N 6081N495WCNew Piper PA-28-181 · S/N 2843620N12881Heath CNA-40 · S/N C-51N485CACessna 210L · S/N 21059819N333GSPiper PA-34-200 · S/N 34-7350046N1177JAero Commander 112 · S/N 177N56913Piper PA-28-140 · S/N 28-7425063N6717UMooney M20C · S/N 2449N9045AAdams Balloon A50S · S/N 037N6625TCessna 150A · S/N 15059025
Back to Lexington, KY