Wilmington, OH
Registered aircraft · 139
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 = 'OH' AND g.registrant_city = 'WILMINGTON' 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 = 'OH' AND g.registrant_city = 'WILMINGTON' 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.
N1042AS+ AC 4 · S/N 042N113DHDJI T50 · S/N DJI3WWDZ-40B08A32N1276TPiper PA-28-140 · S/N 28-7225393N1388BLuscombe 8F · S/N 6015N1643PPiper PA-22-150 · S/N 22-2459N180HSCessna 180J · S/N 18052597N182HLCessna 182P · S/N 18261843N219CYBoeing 767-383 · S/N 24358N220CYBoeing 767-383ER · S/N 24729N221GMMay George F JR ZODIAC 601 XL · S/N 6-4956N2229DCessna 170B · S/N 20381N226CYBoeing 767-383ER · S/N 26544N227AZBoeing 767-323 · S/N 27448N227CYBoeing 767-316 · S/N 26327N229AZBoeing 767-323 · S/N 27059N233AZBoeing 767-323 · S/N 29430N234AXBoeing 767-224 · S/N 30436N237CMBoeing 767-333 · S/N 25584N239AZBoeing 767-323 · S/N 27450N241AZBoeing 767-323 · S/N 27451N251AZBoeing 767-323ER · S/N 29604N254DJDJI AGRAS T30 · S/N 3U5BJ6L0010015N255CMBoeing 767-223 · S/N 22316N257AZBoeing 767-323 · S/N 29605N269CMBoeing 767-333 · S/N 25586N271CMBoeing 767-223 · S/N 22319N283CMBoeing 767-381 · S/N 40566N290CMBoeing 767-381 · S/N 40564N2932WChristen Industries A-1 · S/N 1084N298CMBoeing 767-381 · S/N 40565N307AZBoeing 767-338 · S/N 28725N311AZBoeing 767-338 · S/N 25316N312AABoeing 767-223 · S/N 22315N313AZBoeing 767-338 · S/N 24930N317AZBoeing 767-323 · S/N 25445N317CMBoeing 767-338 · S/N 24317N319CMBoeing 767-338 · S/N 24407N321CMBoeing 767-323 · S/N 29431N331AZBoeing 767-319 · S/N 24875N337AZBoeing 767-323 · S/N 27060N344CMBoeing 767-319 · S/N 28745N347AZBoeing 767-319 · S/N 26264N347CMBoeing 767-323 · S/N 26995N349CMBoeing 767-323 · S/N 26996N351CMBoeing 767-323 · S/N 25201N353AZBoeing 767-323 · S/N 25198N359AZBoeing 767-323 · S/N 24036N362CMBoeing 767-338 · S/N 24316N363CMBoeing 767-338 · S/N 24853N364CMBoeing 767-338 · S/N 24531
Back to Wilmington, OH