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.

N1208FYukon Air Service Inc · Fairbanks, AKBuilt 1975 · S/N 18502771 N1211FGarner Greg A · Renton, WABuilt 1975 · S/N 18502774 N1217FUnited States Department Of Interior · Boise, IDBuilt 1975 · S/N 18502779 N121EESheldon Air Service LLC · Anchorage, AKBuilt 1979 · S/N 18503765 N1222FVelocity Sport LLC · Cedar Falls, IABuilt 1975 · S/N 18502784 N1225QDupont Larry W · North Hero, VTBuilt 1977 · S/N 18503472 N1227FPeterson Investments Inc · Polson, MTBuilt 1975 · S/N 18502789 N122VCTurner Terrance A · Anchorage, AKBuilt 1973 · S/N 18502203 N1231FRegistration Pending · Wasilla, AKRegistration pendingBuilt 1975 · S/N 18502793 N1232FLloyd Land Plane I LLC · Brighton, COBuilt 1975 · S/N 18502794 N1234YDe Jong Thomas · Buckeye, AZBuilt 1980 · S/N 18503944 N1236FPitcher Michael C · Mancelona, MIS/N 18502796 N1237Fraser Mark L · Fairfield, CABuilt 1980 · S/N 18504021 N1239FValpey R Wesley Jr · Medford, MEBuilt 1975 · S/N 18502799 N123EPFalkenberg Randy J · Edmonson, TXBuilt 1976 · S/N 185-03216 N124UAKagerer John A Trustee · Anchorage, AKBuilt 1976 · S/N 18503022 N1253QLibbyn The Dream Fishing Team LLC · Anchorage, AKS/N 18503473 N125KTRustair Inc · Anchorage, AKBuilt 1977 · S/N 18503494 N1282FRainbow River Lodge Aviation LLC · Alpine, UTS/N 18502806 N1285FWill Rittner E · Sevierville, TNBuilt 1975 · S/N 18502809 N1286FTaylor Aviation Inc · Mazama, WAFirst renewal noticeBuilt 1975 · S/N 18502810 N1292FRustair Inc · Anchorage, AKBuilt 1975 · S/N 18502668 N1296FWalker Brandon · Anchorage, AKBuilt 1975 · S/N 18502816 N129KTFowler Andy D · Anchorage, AKBuilt 1975 · S/N 18502812 N129LPJag Aviation LLC · Belle Chasse, LABuilt 1980 · S/N 18504088 N129MLarkin Marion J · Salome, AZBuilt 1973 · S/N 18502208 N12ASNewman Scott W · Healdsburg, CABuilt 1973 · S/N 18502271 N12DMIsland Airways LLC · Marion, WIBuilt 1976 · S/N 18502947 N1322FHoffman Michael J · Bethel, AKBuilt 1975 · S/N 18502825 N135NCBalocco Mark E · Sparks, NVBuilt 1980 · S/N 18503992 N1362FOldham Kris D · Anchorage, AKBuilt 1975 · S/N 18502834 N1370QEvans Randall B Trustee · Fallon, NVBuilt 1977 · S/N 18503480 N1373FBaczewski Gary L · San Antonio, TXBuilt 1975 · S/N 18502837 N137LKStubby Wings LLC · Eden Prairie, MNBuilt 1981 · S/N 18504219 N1393FBenham John D · Blanco, TXBuilt 1975 · S/N 18502840 N13WSJohnson Chad H · Houston, TXBuilt 1979 · S/N 18503938 N13WWHurd Steven C · Bangor, MEBuilt 1982 · S/N 18504378 N1431EBrandt Terry R · Hood River, ORBuilt 1979 · S/N 18503840 N143HJHurlburt Ward B IV · Anchorage, AKBuilt 1976 · S/N 18503032 N1467FJetceo LLC · Kalispell, MTBuilt 1975 · S/N 18502845 N1469FSkywagon 185 LLC · Ocala, FLBuilt 1975 · S/N 18502847 N1470QHillyer Joe F · Soldotna, AKBuilt 1977 · S/N 18503483 N1473FSilveira Paul J · Valdez, AKS/N 18502851 N1475FAc Group LLC · Helena, MTBuilt 1975 · S/N 18502853 N14PHHuman Lee · Mercer Island, WABuilt 1981 · S/N 18504323 N151PBParker Scott L · Midland, TXS/N 185-02146 N1551QJdn Plane LLC · Bellevue, WABuilt 1977 · S/N 18503484 N156KCWhitney Aviation LLC · Derry, NHBuilt 1978 · S/N 18503621 N1576HBloom Timothy S · Chugiak, AKBuilt 1977 · S/N 18503309 N1577HKing Wayne T · Anchorage, AKBuilt 1977 · S/N 18503310

Back to Cessna A185F