OpenAirDocs.org
Middletown, DE

Registered aircraft · 347

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 = 'MIDDLETOWN'
  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.

N100KNQuest KODIAK 100 · S/N 100-0257Built 2018 · Rak Kodiak LLCN100TYCessna 182T · S/N 18281337Flyin M LLCN104SPCessna 182P · S/N 18261667Built 1973 · Janaitis Aviation LLCN105LBEclipse EA500 · S/N 000118Built 2008 · Bhk LLCN10946Cessna 150L · S/N 15075157Built 1973 · Eastern Flying Service IncN109CYAgusta A109A II · S/N 7351O'Brien Derrick PN109NANorth American T-6G · S/N 168-109Omega 1 CorpN110TSSloan William T ACRODUSTER TOO SA750 · S/N WTS-1Ez Aero LtdN1112KSilvaire LUSCOMBE 8A · S/N 3839Built 1946 · Daphna IncN111DWZivko Aeronautics EDGE 540 · S/N 0024Built 2000 · Lumcavok Aviation 1 IncN113EAEclipse EA500 · S/N 000152Built 2008 · N113ea IncN1154GCessna 172S · S/N 172S10126Built 2006 · Plane Nonsense IncN115DLBeech B95A · S/N TD-481Built 1961 · J & S Consulting Solutions LLCN1196WAmerican General Acft AG5B · S/N 10118Built 1992 · Grand Sarfari Productions LLCN1198HPiper PA-32R-300 · S/N 32R-7780143Alge AviationN120SRMueller Lawrence D STARDUSTER TOO · S/N 1221LMRed Baron LLCN121SRGrumman G-21A · S/N 1084Built 1940 · Stick And Rudder Aviation IncN122SMCirrus Design SR22T · S/N 1658Built 2018 · Cirrus Aircraft LLCN12545Cessna 172M · S/N 17262060Built 1973 · Plane Nonsense IncN1276YCessna 208B · S/N 208B1113Built 2005 · Jet Rider LLCN1289UCessna T210N · S/N 21064682Built 1982 · Kavak Air IncN128STCessna 208B · S/N 208B1133Built 2005 · Jet Rider LLCN133RSPiper J3C-65 · S/N 16296Built 1946 · Bootcamp Helicopters LLCN1351RBeech A36TC · S/N EA-21Built 1979 · N1351r IncN1382VColumbia Aircraft Mfg LC41-550FG · S/N 41653Built 2006 · Propair400 LLCN140JNPiper PA-28-140 · S/N 28-7325244Built 1973 · Mfd Aviation IncN141JHHollis C J Inman EVOLUTION · S/N 20Built 2012 · Ez Aero LtdN143BBCessna 172C · S/N 17249516N62689 IncN14429Canadian Car & Foundry HARVARD MK IV · S/N CCF-4-74Built 1952 · Tjd1 LLCN147LFFechter Lothar DEFIANT · S/N 161Red Baron LLCN147LRCaldwell Lapsley R CALDWELL-RV-7 · S/N 71762Built 2008 · Van Kouwenberg GordonN150YACessna 150B · S/N 59377Non-citizen corporation, flight hours not reportedTrans Atlantic Flight SupportN160DGGrunick Dl/Ashby Da RV-4 · S/N 3150Red Baron LLCN16186Stinson SR-8B · S/N 9768Built 1936 · Omega 1 CorpN1669KLuscombe 8E · S/N 4396Built 1946 · Daphna IncN1711KSilvaire LUSCOMBE 8E · S/N 4438Built 1946 · Normandy Flyers Limited IncN172MFCessna 172K · S/N 17258001Rhody Skyhawk Flying Club LLCN1799RCessna A185F · S/N 18502515Built 1974 · Air Support 1 IncN179ASCostruzioni Aeronautiche Tecna P2008 · S/N 128Built 2017 · Lakeview Aviation LLCN179PCAmerican Champion 8KCAB · S/N 1029-2006Msb Aero LLCN1805RBeech A36 · S/N E-1867Built 1981 · Flying Ventures LLCN1823XCessna 182H · S/N 18255923Built 1964 · N1823x LLCN182JWCessna 182K · S/N 18258366Built 1967 · Agri-Air Service IncN184BBell 47D1 · S/N 45Built 1959 · Taz Air Service IncN188BHBeech B-60 · S/N P-526Built 1980 · Jetspeed Solutions LLCN1946TPiper PA-28R-200 · S/N 28R-7135140Built 1971 · Dja Aviation LLCN200KBLearjet 31A · S/N 098Built 1994 · Rainier Jets LLCN2022MPiper J3C-65 · S/N 20787Registration pendingBuilt 1946N2024VBeech V35B · S/N D-10165Built 1978 · Whiskey Tango Flyers IncN205JRTomark Aero CZ Sro VIPER SD-4 · S/N 0099Salt Meadow LLC
Back to Middletown, DE