Skip to content

Registered aircraft · 1,121

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.

N375HPCraig E Rappe · Wasilla, AKBuilt 1976 · S/N 18503235 N375PWRyan Adrian B · Anchorage, AKBuilt 1979 · S/N 18503965 N375WVictory Holdings LLC · Anacortes, WABuilt 1978 · S/N 18503598 N379JTN379jt LLC · Spokane, WABuilt 1978 · S/N 18503629 N37BCBarnes David L · Palmer, AKBuilt 1976 · S/N 18502965 N37RFAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1977 · S/N 18503447 N3868QLibbys Sporting Camps Inc · Chapman, MEBuilt 1973 · S/N 18502205 N3876VKramer William L · Big Lake, AKBuilt 1981 · S/N 18504167 N3885QGades Allen L Trustee · Montevideo, MNBuilt 1973 · S/N 18502207 N38FCEagle Aero Inc · Lafayette, LABuilt 1980 · S/N 18504145 N38FGPatten Mark Samuel · Anchorage, AKBuilt 1979 · S/N 18503920 N3903QWashington Chinook LLC · Bellingham, WABuilt 1973 · S/N 18502209 N3946QSwihart Matthew · Hood River, ORBuilt 1973 · S/N 18502213 N3953PSowards David C · Fairbanks, AKBuilt 1976 · S/N 18503090 N3953QQueen Anne Air LLC · Seattle, WAS/N 18503422 N3969QRegistration Pending · Greeley, CORegistration pending, canceledBuilt 1974 · S/N 18502216 N3992QWisberg Robert E · Bonners Ferry, IDBuilt 1973 · S/N 18502218 N3994QSchneider Don C · Juneau, AKBuilt 1973 · S/N 18502220 N39CCWard Bobby J · Dalhart, TXBuilt 1975 · S/N 18502858 N39FCStout Keith · Salmon, IDBuilt 1979 · S/N 18503923 N400KClydesdale Asset Management LLC · Park City, UTBuilt 1979 · S/N 18503889 N401DSalsola Logistics LLC · Douglas, WYBuilt 1977 · S/N 18503517 N401WCNakochna River Resort LLC · Willow, AKS/N 18502235 N403BSRogness Joshua D · Wasilla, AKS/N 18503527 N404RGJoyner James M · Eagle River, AKS/N 18502702 N406NWJohnson Aeronautics LLC · Billings, MTBuilt 1981 · S/N 18504244 N4095AValiair Limited Company Trustee · Casper, WYBuilt 1979 · S/N 18503910 N409PKSky Cowboy Supply Co LLC · Cape Elizabeth, MEBuilt 1978 · S/N 18503721 N410PKEnergy And Environment LLC · Fayette, MES/N 18503358 N411AArnold Aviation & Thunder Mountain Express Inc · Cascade, IDBuilt 1979 · S/N 18503748 N413LBOficinas De Carolina Inc · San Juan, PRBuilt 1981 · S/N 18504200 N4185MRoom Nine LLC · Casper, WYBuilt 1974 · S/N 18502416 N4211CState Of Colorado Department Of Natural Resources · Denver, COFirst renewal noticeBuilt 1979 · S/N 18503823 N4220QWhitefish Aero Services LLC · Crosslake, MNBuilt 1973 · S/N 18502225 N422BKCarroll John H · Newnan, GABuilt 1972 · S/N 18502121 N4232QRamstad Trygg J · Anchorage, AKS/N 18502227 N4236QTyrrell Jerry R · Woodland, WABuilt 1973 · S/N 18502228 N424RCLatshaw Bonnie Stewart Trustee · Tulsa, OKS/N 18504071 N426MBTimothy Harty · New Richmond, WIBuilt 1984 · S/N 18504420 N4273RYuknis Leonard F · Wasilla, AKBuilt 1976 · S/N 18502924 N4280QHines Thomas J · Amsterdam, NYBuilt 1973 · S/N 18502230 N428AKOlsen Martin G · Anchorage, AKBuilt 1976 · S/N 18502917 N4300QFarwell Christopher J Trustee · Olympia, WABuilt 1973 · S/N 18502232 N4309RWest Atlantic Transportation Corp · Mount Pleasant, NCBuilt 1976 · S/N 18502928 N430RPSale Reported · Billings, MTSale reportedBuilt 1976 · S/N 18503244 N4319RWoodland William B · Anchorage, AKFirst renewal noticeBuilt 1976 · S/N 18502931 N434JGGordon Adam Leo · Oakdale, LABuilt 1979 · S/N 18503785 N4354RNoel Laura · Erie, COBuilt 1976 · S/N 18502937 N4356RTailwind Innovations Inc · Overland Park, KSS/N 18502939 N4358QPeters Nicholas J · Eagle River, AKBuilt 1973 · S/N 18502237

Back to Cessna A185F