Lewes, DE
Cancelled registrations · 294
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 = 'DE' AND d.registrant_city = 'LEWES' 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 = 'DE' AND d.registrant_city = 'LEWES' 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.
N4030XAero Commander 100-180 · S/N 5130N58JJJackson Jacob J GP-4 · S/N 002N116SVCessna 172S · S/N 172S9815N4698SNorth American T-28B · S/N 137706N4412SPiper PA-34-220T · S/N 3449487N15349Piper PA-32-260 · S/N 32-7300005N750TBCessna 550 · S/N 550-0579N146BBMatt Mcswain JA30 SUPERSTOL · S/N JA335-12-13N280BPRyan NAVION · S/N NAV-4-2027N921CCRockwell International NA-265-65 · S/N 465-67N479AGCessna 421C · S/N 421C0612N735TNCessna 182Q · S/N 18265672N996JTHonda HA-420 · S/N 42000229N220DMRobinson Helicopter R22 MARINER · S/N 0928N1401FCessna 172H · S/N 17254896N857PFWsk-Mielec AN-2 · S/N 1G10857N62478Piper PA-23-250 · S/N 27-7654006N917LEIsrael Aircraft Industries 1124A · S/N 400N269AGNanchang China CJ-6A · S/N 3532007N756FDCessna R182 · S/N R18201060N9769NCessna U206A · S/N U2060494N703RTCessna 500 · S/N 500-0114N11874Cessna 150L · S/N 15075678N970RPCessna 500 · S/N 500-0270N435RBBeech V35 · S/N D-8355N121DLPiper PA-28-161 · S/N 28-8016115N1059UPiper PA-34-200 · S/N 34-7250043N37971Gates Learjet 25D · S/N 358N50VJMoravan ZLIN Z50 LS · S/N 0048N306SKCessna 404 · S/N 404-0131N18416Stinson SR-9C · S/N 5318N4432BPiper PA-32RT-300T · S/N 32R-7887174N969JMCirrus Design SR22T · S/N 0714N200DZBeech A200 · S/N BC-58N420JCGulfstream Aerospace G-1159A · S/N 326N8108GCessna T310Q · S/N 310Q1047N104CJWsk-Pzl Mielec MIG-15 UTI (LIM2) · S/N 1A01004N1958QCessna 177RG · S/N 177RG0358N62769Piper PA-23-250 · S/N 27-7754010N6556KCessna 172P · S/N 17274212N897KCDiamond Aircraft Ind DA 40 · S/N 40.897N660WCCessna 210L · S/N 21061027N25328Fairchild 24W-40 · S/N W40-114N2452ABeech V35A · S/N D-9047N54793Piper PA-23-250 · S/N 27-7554095N290VPCessna 550 · S/N 550-0090N2367RPiper PA-28-180 · S/N 28-5498N556JSReims CESSNA F172G · S/N 0197N911DSCessna P210N · S/N P21000787N302TCPiper PA-31-325 · S/N 31-7912033
Back to Lewes, DE