Skip to content

Registered aircraft · 488

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 ('2072722')
  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 ('2072722')
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.

N2952FFisher Cody · Ennis, TXBuilt 1966 · S/N 18257052 N2954FWestberg Wayne A · Harvey, IABuilt 1966 · S/N 18257054 N2955FBoyd John W · Milton, WABuilt 1966 · S/N 18257055 N2961FNilssen Carl J · Cameron, WIBuilt 1966 · S/N 18257061 N2962FMcclevey Landon Kole · Dilley, TXBuilt 1966 · S/N 18257062 N2963FConnell Gary A · Anchorage, AKS/N 18257063 N2964FHunt Stuart J · Lynn Haven, FLBuilt 1966 · S/N 18257064 N2965FFrank Paul R · Waukesha, WIBuilt 1966 · S/N 18257065 N2966FNansen Peter D · Bellingham, WABuilt 1966 · S/N 18257066 N2971FHaglund Jennifer J · Beaverton, ORBuilt 1966 · S/N 18257071 N2972FPolus9 LLC · Houston, TXBuilt 1966 · S/N 18257072 N2974FCook Bentley · Sewanee, TNBuilt 1966 · S/N 18257074 N2976FBates Joseph E · Providence, UTBuilt 1966 · S/N 18257076 N2977FWhitesitt H Dean · Stevensville, MTBuilt 1966 · S/N 18257077 N2978FNewman James Clayton · Tyler, TXBuilt 1966 · S/N 18257078 N2983FHalle Michael P · Livingston, TXBuilt 1966 · S/N 18257083 N2987FRegistered aircraftBuilt 1966 · S/N 18257087 N2988FTaf Aerial Services LLC · Beeville, TXBuilt 1966 · S/N 18257088 N2991FBerryessa Alan E · Cedarville, CABuilt 1966 · S/N 18257091 N2993FDaniels Aviation Inc · Inverness, MSS/N 18257093 N2995FCj3 Aviation LLC · Idaho Falls, IDBuilt 1966 · S/N 18257095 N2996FSmooth Air LLC · Mequon, WIBuilt 1966 · S/N 18257096 N2998FChristian Halls International · Arlington, TXBuilt 1966 · S/N 18257098 N3003FHassinger Farms LLC · Cove, ORBuilt 1966 · S/N 18257103 N3004FN3004f LLC · Cranberry Township, PABuilt 1966 · S/N 18257104 N3005FE & E Jones Farms LLC · Munford, ALBuilt 1966 · S/N 18257105 N3007FTroelstra Frederick D · Queensbury, NYBuilt 1966 · S/N 18257107 N300BWWatson Brent J · Bountiful, UTBuilt 1965 · S/N 18256725 N300DFDowner Justin W · Berthoud, COBuilt 1966 · S/N 18257109 N300EMMark Thomas Productions LLC · Ketchum, IDBuilt 1966 · S/N 18257529 N3013FElwell David L · Coolidge, AZFirst renewal noticeBuilt 1966 · S/N 18257113 N3014FBrown Kimberly L · Tucson, AZBuilt 1966 · S/N 18257114 N3016FLosleben William L · Duvall, WABuilt 1966 · S/N 18257116 N3018FDietzler James J · Weyauwega, WIBuilt 1966 · S/N 18257118 N3019FMadison Richard Christopher · Little Rock, ARBuilt 1966 · S/N 18257119 N3021FRegistered aircraftBuilt 1966 · S/N 18257121 N3023FJones Clinton D · Santa Rosa Beach, FLBuilt 1966 · S/N 18257123 N3024FSutton Aircraft Salvage LLC · Palmer, AKBuilt 1966 · S/N 18257124 N3025FWarner Daniel M · Fremont, OHBuilt 1966 · S/N 18257125 N3026FMock1 LLC · Abingdon, VABuilt 1966 · S/N 18257126 N3027FSale Reported · Watford City, NDSale reported, pending cancellationBuilt 1966 · S/N 18257127 N3030FThirty Thirty Club · Lebanon, ORBuilt 1966 · S/N 18257130 N3031FAlderson John M · Venice, CABuilt 1966 · S/N 18257131 N3038FTaylor Spencer H · Lake City, FLBuilt 1966 · S/N 18257138 N3040FJump Tn LLC · Greeneville, TNBuilt 1966 · S/N 18257140 N3041FRoffey Edward P Trustee · Grand Junction, COBuilt 1966 · S/N 18257141 N3042FTdc Aviation LLC · Scottsdale, AZBuilt 1966 · S/N 18257142 N3045FFinley Eric · Ione, CABuilt 1966 · S/N 18257145 N3046FPlane Brilliant · Odessa, FLS/N 18257146 N3049FFriendship Flying Service Inc · Lexington, KYBuilt 1966 · S/N 18257149

Back to Cessna 182J