Skip to content

Registered aircraft · 252

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('2072818')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2072818')
ORDER BY 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.

N4573FNapflin Erich P · Wasilla, AKBuilt 1966 · S/N 185-1080 N4574FKlingenmeyer Korey L · Anchorage, AKBuilt 1966 · S/N 185-1081 N4579FWagner Jan W · Lopez Island, WAS/N 185-1086 N4596FJaysix LLC · Greeley, COBuilt 1966 · S/N 185-1150 N4597FWarden Richard L · Canby, ORBuilt 1966 · S/N 185-1151 N460CCAmerican Falconry Inc · Dayton, WYBuilt 1966 · S/N 185-0993 N4701QWindsor Greg A · Anchorage, AKBuilt 1966 · S/N 185-1155 N4706QRegistration Pending · Polson, MTRegistration pendingBuilt 1966 · S/N 185-1160 N4708QCole Brent R · Anchorage, AKBuilt 1966 · S/N 185-1162 N4710QNeitz Frank A · Bethel, AKBuilt 1966 · S/N 185-1164 N4720QFielding William J IV · Scarborough, MES/N 185-1174 N4721QXtreme Attitudes LLC · Sanford, NCBuilt 1966 · S/N 185-1175 N4730QLindsey Brad A · Dubois, WYBuilt 1966 · S/N 185-1184 N4738QNeal Tyler W · Dufur, ORBuilt 1967 · S/N 185-1192 N4740QFitzpatrick D L III · Whitefish, MTBuilt 1966 · S/N 185-1194 N47428Nei Jeffrey G · Bemidji, MNBuilt 1966 · S/N 185-1196 N4743QHabersetzer Brian D · Brush Prairie, WABuilt 1967 · S/N 185-1197 N4747QRoss Andrew P · Romoland, CAS/N 185-1201 N4750QDelaware C Plane Inc · Wilmington, DES/N 185-1204 N4755QCook Alfred M · Juneau, AKBuilt 1967 · S/N 185-1212 N4757QKroenke Seth M · Palmer, AKS/N 185-1216 N4759QPease Robert J · Anchorage, AKBuilt 1967 · S/N 185-1220 N4761QMichaelson Lawrence · Big Lake, AKBuilt 1967 · S/N 185-1226 N4764QShapiro David · Homer, AKBuilt 1967 · S/N 185-1230 N4772QHodgson John P · Atlanta, GABuilt 1967 · S/N 185-1239 N4775QShelk John Brian · Bend, ORBuilt 1967 · S/N 185-1242 N48061Olsen Mark G Trustee · Ketchikan, AKBuilt 1966 · S/N 185-1084 N4MACoral Key Air Inc · Brookhaven, NYBuilt 1972 · S/N 18502044 N50AUDapp Eric M · Corvallis, ORS/N 1851368 N515MAAdams Scott M · Seabrook, TXS/N 1851070 N518HJArmstrong Consolidated LLC · Anchorage, AKBuilt 1971 · S/N 18501930 N531HAcadian Aircraft Leasing LLC · Rangeley, MEBuilt 1968 · S/N 185-1348 N54LLRyan Good Aviation LLC · Sioux Falls, SDBuilt 1968 · S/N 185-1463 N550RWNine Six Livestock Co · Sterling City, TXBuilt 1972 · S/N 18502015 N55LWLeeward Aero Sales Corp · Ocala, FLS/N 1851185 N572EEcho Air LLC · Anchorage, AKBuilt 1972 · S/N 18502089 N574MTGrow Michael J · Palmer, AKBuilt 1967 · S/N 185-1247 N5805JLanni Ronald A · Fairbanks, AKBuilt 1970 · S/N 18501774 N5807JForsgren Keith C · Wasilla, AKBuilt 1970 · S/N 18501776 N5812JBedford Dennis L · Auke Bay, AKBuilt 1970 · S/N 18501781 N5830JMontague Brett A · Van Buren, OHBuilt 1970 · S/N 18501799 N5836JMeyerkorth Aviation LLC · Rock Port, MOBuilt 1970 · S/N 18501805 N5849JFowler Jon E · Hallock, MNBuilt 1970 · S/N 18501818 N5859JWillis Tyler L · Wasilla, AKS/N 18501819 N601Mont Belvieu Materials Inc · Mont Belvieu, TXBuilt 1969 · S/N 185-1567 N641DACavu Aviation LLC · Lake Geneva, WIBuilt 1970 · S/N 18501619 N65EAPhilbrick Quinn R · Rangeley, MEBuilt 1966 · S/N 1850997 N67DSHangar 39 LLC · Culpeper, VAS/N A185E1284 N691DETilton Joseph J · Willow, AKBuilt 1968 · S/N 185 1310 N694BKBell Bruce · Desert Aire, WABuilt 1969 · S/N 1851582

Back to Cessna A185E