Skip to content

Registered aircraft · 1,120

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 ('2072821', '2070107')
  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 ('2072821', '2070107')
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.

N1005FBeam Douglas J Trustee · Chugiak, AKBuilt 1975 · S/N 18502677 N1015FInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 18502684 N1022FGoodfellow Malcolm D · Seattle, WABuilt 1975 · S/N 18502690 N1023FWinter Karl · Litchfield Park, AZBuilt 1975 · S/N 18502691 N1028FLunoe Leif C · Anchorage, AKBuilt 1975 · S/N 18502695 N103AMN103am LLC · Chehalis, WABuilt 1974 · S/N 18502615 N1040FMarrs Matthew D · Bentonville, ARBuilt 1975 · S/N 18502697 N1043FBakkes Francois · Sitka, AKBuilt 1975 · S/N 18502700 N1047FBondurant Jok · Talkeetna, AKS/N 18502704 N104BWJurak Mike D · Kimberly, IDBuilt 1974 · S/N 18502517 N104DEVince John G · West Ossipee, NHBuilt 1980 · S/N 18504009 N104HEDixie Sand And Gravel LLC · Edisto Island, SCBuilt 1975 · S/N 18502742 N104TRAuburn Sheet Metal Inc · Enumclaw, WABuilt 1976 · S/N 18503212 N1050FBuchan John F · Port Ludlow, WABuilt 1975 · S/N 18502707 N1052FGlb Farms Inc · Pasco, WABuilt 1975 · S/N 18502709 N1056FBrasil John I · Lemon Grove, CABuilt 1975 · S/N 18502712 N105NBNorthcentral Aircraft LLC · Blaine, MNBuilt 1984 · S/N 18503732 N1060FStrausbaugh Paul L · Clifton Forge, VABuilt 1975 · S/N 18502716 N1062FSale Reported · Independence, ORSale reportedBuilt 1975 · S/N 18502718 N1074FNorth River Air LLC · Fairbanks, AKBuilt 1975 · S/N 18502730 N1076FCavu Clearing LLC · Center Harbor, NHS/N 18502732 N1077ABabcock Mark E · Auburn, WABuilt 1977 · S/N 18503156 N1077FScileppi Gregory S · Sea Island, GABuilt 1975 · S/N 18502733 N1078FWilliams Casey D · Wasilla, AKBuilt 1975 · S/N 18502734 N107LHale Mitchell D · Chugiak, AKBuilt 1978 · S/N 18503535 N107TYThornock Ty D · Shawano, WIS/N 18502836 N1084FSiktberg Timothy J · Nashville, TNBuilt 1975 · S/N 18502739 N1089FWells Thomas J · Big Lake, AKBuilt 1975 · S/N 18502744 N1095FEggart Lawrence D · Nome, AKS/N 18502750 N1099FSaal Christopher J · Anchorage, AKBuilt 1975 · S/N 18502754 N10JVHale Thomas O · Cotuit, MABuilt 1973 · S/N 18502242 N1102GGlassy Water LLC · Brier, WABuilt 1977 · S/N 18503521 N11179Holloway David · Auburn, CABuilt 1985 · S/N 18504436 N11185Stancil Joe E Jr · Eagle River, AKBuilt 1980 · S/N 18504044 N111BLLandry Patrick Todd · Georgetown, TXBuilt 1979 · S/N 18503877 N111CAce'S Hangar LLC · Bentonville, ARBuilt 1974 · S/N 18502600 N111EYHook Steven · Pasco, WABuilt 1974 · S/N 18502407 N111GN111g LLC · Longmont, COBuilt 1974 · S/N 18502507 N113TBBeaudoin Todd · Castleton, NYS/N 18503772 N1145FGurke George J · Anchorage, AKBuilt 1975 · S/N 18502757 N115AWMillican Marc J · Anchorage, AKBuilt 1976 · S/N 18502941 N1169QRohde Allen G · Eagle River, AKBuilt 1977 · S/N 18503466 N118AEdgerton George Murray Trustee · Redding, CABuilt 1977 · S/N 18503339 N1197FSchumacher Bradley M · Lewiston, IDBuilt 1975 · S/N 18502763 N119DSDeltasierra LLC · Staunton, VABuilt 1979 · S/N 18503735 N11ATChan Roger J · Anchorage, AKBuilt 1974 · S/N 18502547 N11CSilicz Nicholas J · Shafter, CABuilt 1975 · S/N 18502713 N11CEMelcher Pierre S · New Braunfels, TXBuilt 1974 · S/N 18502512 N1204FMoroney Aviation LLC · Chugiak, AKBuilt 1975 · S/N 18502767 N1206FHarrah Daniel R · Juneau, AKBuilt 1975 · S/N 18502769

Back to Cessna A185F