Milton, DE
Registered aircraft · 46
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 = 'MILTON' 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 = 'MILTON' 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.
N158BMBeech 58 · S/N TH-1244N1697HPiper PA-28-161 · S/N 28-7716046N17298Cessna 150L · S/N 15073711N172PHCessna 172E · S/N 17250918Registration pendingN21358Cessna 182P · S/N 18261585N21393Cessna 182P · S/N 18261607N2268WBell 206B · S/N 3606N232SBCessna 182S · S/N 18280211N263JCThrush S2RHG-T34 · S/N T34HG-105N3055MThrush S2R-T34 · S/N T34-381N3299DAyres S-2R · S/N 2589RN330DMMikel Dennis W RANS S7S · S/N 1207493N4001ABeech AT-11 · S/N 43-10384N422JCAir Tractor AT-802A · S/N 802A-0762N423LFAlon A2 · S/N A-15N4284BBeech F35 · S/N D-4258N459BGPreiser Gerard A COZY MARK 4 · S/N 1390N496KPPhilcox Kenneth J TR-1 KIS · S/N 020N519DECirrus Design SR22 · S/N 1964N5201LMooney M20J · S/N 24-0580N53488Boeing A75N1(PT17) · S/N 75-2284N5552ABeech C18S · S/N 8431N562XThrush S2R-T34 · S/N T34-380N567JCGrumman Acft ENG Cor-Schweizer G-164A · S/N 1340N5779FPiper PA-28-140 · S/N 28-25085N619PFAir Tractor AT-802A · S/N 802A-0619N626TSAir Tractor AT-602 · S/N 602-1221N62ACCessna 182P · S/N 18264345N6401CDJI AGRAS T50 · S/N 7TNBMDM004058XN6577TCessna 150 · S/N 17977Registration pendingN67013Beech C23 · S/N M-2229N684SRCirrus Design SR22 · S/N 2816N7070CNorth American SNJ-4 · S/N 88-13164N74452Grumman American Avn. AA-5B · S/N AA5B-0231N7497HPiper J3C-65 · S/N 20766N83515Aeronca 7DC · S/N 7AC-2186N8420RPiper PA-28-140 · S/N 28-22349N862MBell 206B · S/N 4473N891JCAyres S2R-T34 · S/N T34-269N8967HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1599N909XGrumman G-164A · S/N 501N9223JPiper PA-28-180 · S/N 28-3293N9277HCessna 172M · S/N 17266065N946BFEngineering & Research ERCOUPE 415-C · S/N 3043N9657VCessna 172M · S/N 17264437N9984YChampion 7EC · S/N 7EC-769
Back to Milton, DE