Camden, DE
Registered aircraft · 162
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'DE' AND g.registrant_city = 'CAMDEN' ORDER BY g.n_number"
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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'DE' AND g.registrant_city = 'CAMDEN' ORDER BY g.n_number
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.
N1037WPiaggio Aero Industries P180 · S/N 1037N1052ACirrus Design SR22T · S/N 1333N105LCMesserschmitt BO105CBS · S/N S789N106MCCirrus Design SR22T · S/N 1877N107LSCostruzioni Aeronautiche Tecna P92 ECHO SUPER · S/N 980N109LRAgusta A109A II · S/N 7416N10DRPiper PA-34-220T · S/N 3448044N110EACessna A150L · S/N A1500309N115AMBoeing 737-9 · S/N 43371N1236XMooney M20E · S/N 109N128AMBoeing 787-9 · S/N 65313N133GCirrus Design SR22T · S/N 0135N143WYCub Crafters CC19-215 · S/N CC19-0093N1450MCessna U206E · S/N U20601450N158SKTextron 560XL · S/N 560-6267N171CSCessna T240 · S/N T24002071N183AMBoeing 787-9 · S/N 60285N18JXCirrus Design SF50 · S/N 0056N1909RBell 206B · S/N 1909N196SRCirrus Design SR22 · S/N 2750N19ZCCirrus Design SF50 · S/N 0109N20DGShakedown Street SW-51 · S/N SW-51-032N20TWCirrus Design SF50 · S/N 0090N212LVCirrus Design SR20 · S/N 1547N217CTCirrus Design SR22T · S/N 1475N217PTDassault-Breguet FALCON 50 · S/N 163N228JPCessna 182S · S/N 18280711N234ETCirrus Design SR22 · S/N 11257N248LKCirrus Design SR22 · S/N 10819N249HPGates Lear Jet 24D · S/N 301Sale reportedN258CSSchotanus Myron BELL/MSOH58 · S/N 002N260LRBell 206B · S/N 3613N272WTCirrus Design SF50 · S/N 0096N277TBBell 206L-3 · S/N 51189N280FLIai GULFSTREAM G280 · S/N 2261N286MHBombardier BD-100-1A10 · S/N 20400N28MGBeech 58 · S/N TH-1535N300SEBeech 300 · S/N FA-68N300SMPilatus PC-12/47E · S/N 2021N304PSBombardier BD-100-1A10 · S/N 20059N30FSNxcub One CCX-2300 · S/N CCX-2300-0093N312DXCirrus Design SR22T · S/N 2113N312MGCirrus Design SR22T · S/N 1874N312XXCirrus Design SR22T · S/N 8925N313JLDassault FALCON 900EX · S/N 192N317TMPiper PA-46-701TP · S/N 46020037N32GCCirrus Design SF50 · S/N 0722N32MFCirrus Design SR22 · S/N 4437N33ZGCirrus Design SR22T · S/N 10316N35BGMikoyan Gurevich MIG 15UTI · S/N 1A10017
Back to Camden, DE