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.

N2772JMagoffin David S · Fairbanks, AKBuilt 1969 · S/N 185-1522 N2776JMission Aviation Fellowship · Nampa, IDS/N 185-1526 N2777JFirst Flight LLC · Craig, AKBuilt 1969 · S/N 185-1527 N2778JWilfer Dennis M · Fairbanks, AKBuilt 1969 · S/N 185-1528 N2781JRussell Scott M · Sanger, TXBuilt 1969 · S/N 18501531 N2785JDurtschi Steven R · Centerville, UTBuilt 1969 · S/N 185-1535 N2787JLarson Jared E · Wasilla, AKBuilt 1969 · S/N 185-1537 N278HJJohnson Joel P · Duluth, MNBuilt 1967 · S/N 185-1268 N2792JAndresen Leonard W · Anchorage, AKBuilt 1969 · S/N 185-1542 N2794JRegistration Pending · Anchorage, AKRegistration pendingBuilt 1969 · S/N 185-1546 N2797JAlaska Ultimate Safaris LLC · Homer, AKBuilt 1969 · S/N 185-1555 N303RJTr Zato Heir Land & Cattle LLC · Spur, TXBuilt 1970 · S/N 18501728 N305SLSealand Airways Miami LLC · Miami, FLBuilt 1968 · S/N 185-1433 N3086WAltair Aircraft LLC · Gainesville, FLBuilt 1972 · S/N 18502042 N3273MLindeen Michael · Anchorage, AKBuilt 1967 · S/N 185-1210 N331JTJuliet Tango Flying Services LLC · Walnut Creek, CABuilt 1972 · S/N 18501899 N3346LHarper Matthew Clay · Anchorage, AKS/N 185-1274 N3347LAcumen Aerotech LLC · Rogers, TXBuilt 1967 · S/N 185-1275 N3351LGagnon Philip F · Anchorage, AKBuilt 1967 · S/N 185-1303 N3357LMark II Aviation LLC · Corvallis, MTBuilt 1967 · S/N 185-1309 N3371LAgresti Harold David · Ceres, CABuilt 1967 · S/N 185-1323 N3373LHowell Nicholas A · Englewood, COBuilt 1967 · S/N 185-1325 N3374LLewallen William J · Eloy, AZBuilt 1967 · S/N 185-1326 N3375LRowan William · New Fairfield, CTBuilt 1967 · S/N 185-1327 N3385LTonka Seaplanes LLC · Minnetonka, MNS/N 185-1337 N3399LMetz William · Laurel, MTS/N 185-1351 N33FCReece Trucking And Excavating Inc · Marysville, WAS/N 18501631 N3558FPacific Rim Adventures Inc · Los Olivos, CAS/N 185-1438 N36ZNDawkins Christopher R · Trinity, NCBuilt 1970 · S/N 18501830 N406GGCedar Creek Corp · Red Bluff, CABuilt 1967 · S/N 185-1154 N414EDDavis Gabriel L · Dillingham, AKBuilt 1971 · S/N 18501838 N4185PFlying Woody LLC · Helena, MTBuilt 1970 · S/N 185-01651 N418PCHajdu Paul R · Valley Center, KSBuilt 1971 · S/N 185-01843 N4194WNicholson Jon S · Bethel, AKBuilt 1967 · S/N 1851203 N4507FRodriguez Kenneth C · East Wenatchee, WABuilt 1966 · S/N 185-0989 N4517FAeropod Inc · Aurora, COS/N 185-1001 N4520FRegistered aircraftBuilt 1966 · S/N 185-1005 N4530FBean David L · Chandler, AZBuilt 1966 · S/N 185-1015 N4534FSmith Peter A · Gunnison, COBuilt 1966 · S/N 185-1019 N4535FRohde Allen G · Eagle River, AKBuilt 1966 · S/N 185-1021 N4538FLohse Teal K · Cordova, AKBuilt 1966 · S/N 185-1025 N4541FWittnebel Karl · Los Angeles, CAS/N 185-1031 N4546FThomas Craig E · Stevensville, MTBuilt 1966 · S/N 185-1039 N4548FWard Nelson H · Salcha, AKBuilt 1966 · S/N 185-1043 N4549FMetroaire LLC · Mc Kees Rocks, PABuilt 1966 · S/N 185-1045 N4554FFejes Jacob J · Watertown, NYS/N 185-1057 N4557FKincaid Jonathan A · Frankfort, MEBuilt 1966 · S/N 185-1061 N4558FN4558f LLC · Columbus, OHBuilt 1966 · S/N 185-1062 N4562FMcdaniel Dean K · Queen Creek, AZS/N 185-1069 N4572FRichards Stewart G · North Palm Beach, FLBuilt 1966 · S/N 185-1079

Back to Cessna A185E