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.

N21958Hillsboro Aero Ltd · Hillsboro, NDBuilt 1976 · S/N 18503072 N22069Frank Merle R Trustee · Wasilla, AKBuilt 1982 · S/N 18504368 N220TCLanger Brent A · Owatonna, MNBuilt 1973 · S/N 18502153 N22131Kraxberger Rick R · Kasilof, AKBuilt 1976 · S/N 18503074 N222XLFox Jeffery R · Spooner, WIBuilt 1981 · S/N 18504278 N2230DHendricks Construction LLC · Phoenix, AZBuilt 1976 · S/N 18503053 N2233RDorman William James Trustee · Anchorage, AKBuilt 1975 · S/N 18502859 N224CHMadden Jeffrey M · Queensbury, NYBuilt 1976 · S/N 18503075 N22580Carter Benjamin F · Colusa, CABuilt 1976 · S/N 18503076 N228ZFFandrich Edward I · Payson, AZS/N 18502461 N22CBVollstedt Gregory Scott · Anchorage, AKBuilt 1973 · S/N 185-02188 N22FGState Of California Department Of Fish And Game · Sacramento, CABuilt 1983 · S/N 18504407 N23251Smith Lyndsey P Trustee · Anchorage, AKBuilt 1976 · S/N 18503078 N234JSOcean Blue Aviation LLC · Farmingdale, NYBuilt 1976 · S/N 18502956 N23AZNix Jacob DBA · Johnson, KSBuilt 1974 · S/N 18502499 N23LKHernandez Byron Jr · Buffalo, NYBuilt 1976 · S/N 185-03085 N24159Power Alan T · Los Alamos, NMBuilt 1982 · S/N 18504346 N241RDRegistration Pending · Missoula, MTRegistration pendingBuilt 1975 · S/N 18502934 N241WMWildman Air LLC · Mckinney, TXBuilt 1973 · S/N 18502253 N2423ACcf Ventures Inc · Bangor, MES/N 18504225 N2431YBennett Mark · Normangee, TXS/N 18503566 N2449JSkydance Northwestern Inc · Minden, NVBuilt 1982 · S/N 18504364 N24579Grunwaldt Peter J · Anchorage, AKBuilt 1982 · S/N 18504357 N24CJAtluas LLC · Anna, TXS/N 18502199 N24FGCalifornia Department Of Fish And Game · Sacramento, CABuilt 1981 · S/N 18504207 N2532SGrant Roderick M · Dillingham, AKBuilt 1973 · S/N 18502246 N254WGMccauley Thomas I · Puyallup, WABuilt 1978 · S/N 18503572 N2577QSlingsby J Geoffrey · Rapid City, SDBuilt 1977 · S/N 18503520 N2583SMackowiak Michael · Haines, AKBuilt 1973 · S/N 18502250 N2596KPopov Chris · Hope, IDS/N 18504257 N25FGState Of California Department Of Fish And Game · Sacramento, CAS/N 18504113 N25MMFairweather Aviation Leasing LLC · Haines, AKFirst renewal noticeBuilt 1975 · S/N 18502827 N262APKirk Donald D · Fairbanks, AKBuilt 1975 · S/N 18502645 N2659SRovey Gerald A · Troy, IDBuilt 1973 · S/N 18502261 N2675RDotzenroth David A · Watertown, MNS/N 185-02392 N2678SHardy Mikel Gareth · Thatcher, AZBuilt 1973 · S/N 18502265 N26DLHayden David Bernard Trustee · Roach, MOBuilt 1973 · S/N 18502287 N27532Shadow Aviation Inc · Fairbanks, AKBuilt 1979 · S/N 18503688 N275ZZWardell Robert · Montrose AuNon-citizen corporation, flight hours not reportedBuilt 1976 · S/N 18503238 N2783TCloud 9 Aviators LLC · Anchorage, AKBuilt 1981 · S/N 18504350 N278CFInfinity Aviation LLC · Mandan, NDBuilt 1981 · S/N 18504228 N2821QHattan Richard A Trustee · Fairbanks, AKBuilt 1977 · S/N 18503533 N28JEWallace Coke W · Healy, AKS/N 18502911 N2902QHeihn Daniel M · Soldotna, AKS/N 18503539 N2903QTwin Fiddle Investment Aeronautics LLC · Atlanta, GABuilt 1978 · S/N 18503540 N2904QBoley Richard J · Hayward, WIBuilt 1978 · S/N 18503541 N2906QCage James D · Muleshoe, TXS/N 18503542 N29SRAviation USA LLC · Anchorage, AKBuilt 1978 · S/N 18503582 N2CWMiller Steven D · Mccall, IDS/N 18502486 N2GAWilson Frank C · Irondale, OHBuilt 1974 · S/N 18502376

Back to Cessna A185F