Skip to content

Registered aircraft · 2,099

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

N21598Kcsi Aerial Patrol Inc · Bakersfield, CABuilt 1973 · S/N 18261742 N216BANordic Flyers II LLC · Plymouth, MNBuilt 1975 · S/N 18263882 N2170MTucknott Robert A · Livermore, CABuilt 1976 · S/N 18265133 N2182PSiemens Mark J · Rocklin, CABuilt 1976 · S/N 18264767 N21LWRegistered aircraftBuilt 1973 · S/N 18261932 N21RHWogan Joseph M · Mesa, AZBuilt 1972 · S/N 18261224 N21TGScott John · Arcadia, FLBuilt 1972 · S/N 18261547 N221MLWamu Fly N Fish LLC · Portland, ORBuilt 1972 · S/N 18261525 N222CTMorency Richard · Houston, TXBuilt 1974 · S/N 18263068 N222ERGjg Air LLC · Amarillo, TXBuilt 1975 · S/N 18263978 N222JHRegistered aircraftBuilt 1974 · S/N 18263066 N222PXRegistered aircraftBuilt 1976 · S/N 18265157 N2277YSheffield Richard Lee · Los Alamos, NMBuilt 1972 · S/N 18261225 N227CMMmkb Inc · Wilmington, DEBuilt 1976 · S/N 18264533 N228JASky Port Inc · Kalispell, MTBuilt 1976 · S/N 18265111 N22NNInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 18263497 N22REStanley Aero Club Inc · Belmont, NCBuilt 1974 · S/N 18263425 N233GSGreenville County Sheriffs Office · Greenville, SCBuilt 1972 · S/N 18261018 N234TMMisakian David L · Novato, CABuilt 1976 · S/N 18264768 N236AMyotis Ltd · Leesburg, VABuilt 1973 · S/N 18262695 N23DHOrtiz Guillermo · Puyallup, WABuilt 1975 · S/N 18264053 N242EMDay Grain Co Inc · Braman, OKBuilt 1974 · S/N 18263224 N244DBAnsari Ramin · West Lafayette, INBuilt 1976 · S/N 18265043 N244RPMitchell N Andrew · Bridgeport, CTBuilt 1973 · S/N 182-62311 N24HPYolo County/Yolo County Sheriffs Office · Woodland, CABuilt 1975 · S/N 18263568 N24VEDuke William Thomas · West Point, MSBuilt 1974 · S/N 18262869 N251RDidier Christopher W · Fay, OKBuilt 1972 · S/N 61139 N260DFMatchbox Holdings LLC · Harrisonburg, VABuilt 1975 · S/N 18264479 N261SSScopellite Sebastian · Phoenix, AZS/N 18261130 N265DTLynn Daniel K · Beaverton, ORBuilt 1975 · S/N 18264034 N26POn Final Flying LLC · Altoona, IABuilt 1973 · S/N 18262090 N26TTSales Call LLC · Robstown, TXBuilt 1973 · S/N 18262570 N272BBearair II LLC · Libertyville, ILBuilt 1975 · S/N 18264193 N275HPRich Aviation Services LLC · Fort Worth, TXBuilt 1976 · S/N 18265173 N277TMPollock Donald Edward · Union Hall, VABuilt 1976 · S/N 18264391 N2799QZerden David F · Lincoln Park, NJBuilt 1972 · S/N 18261592 N281SLCurly Aviation LLC · Atlanta, GABuilt 1972 · S/N 182-61394 N2852GWiebe Peter R · Seminole, TXS/N 18260889 N289CRNiner Charlie Romeo LLC · Simpson, LABuilt 1974 · S/N 18263496 N28ACZiegler Bruce A · Findlay, OHBuilt 1974 · S/N 18263265 N28LFBaker Timothy Scott · Shreveport, LABuilt 1973 · S/N 18261898 N292CBPelton Project · Keizer, ORBuilt 1975 · S/N 18264306 N29821Jks Enterprises Inc · Park Rapids, MNBuilt 1972 · S/N 18261233 N298SMSmb Flyer LLC · Queen Creek, AZBuilt 1973 · S/N 18262327 N29CMChenango 11 LLC · Wilmington, DEBuilt 1976 · S/N 18264793 N2ZDMelin Lynn Glenn · Scottsdale, AZBuilt 1974 · S/N 18262867 N303SDHarris County Sheriff'S Office · Spring, TXBuilt 1973 · S/N 18261849 N306DMWylie Aviation LLC · North Little Rock, ARBuilt 1974 · S/N 18262544 N30GEEagle Air Inc · Schoolcraft, MIBuilt 1976 · S/N 18265130 N313SKJohnson Scott · Blaine, MNBuilt 1973 · S/N 18262630

Back to Cessna 182P