Skip to content

Registered aircraft · 1,565

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

N399NBicknell Brooks E · Andover, NHBuilt 1980 · S/N 18267690 N3BDCopley Johnnie H · Minooka, ILBuilt 1979 · S/N 18267206 N3JPMcbride Scott · Lake Havasu City, AZBuilt 1978 · S/N 18266230 N3UXDiller Christina · Anchorage, AKBuilt 1979 · S/N 18267442 N403PKN403pk LLC · Ada, MIBuilt 1977 · S/N 18265475 N40BBPawlak Jakub Piotr · Lafayette, INBuilt 1977 · S/N 18265944 N411BPAbove All Aviation Inc · Santa Barbara, CABuilt 1977 · S/N 18266177 N411RBOptic Air LLC · St Maurice, IAS/N 18267053 N414SCPaul Sachitano LLC · Beaumont, TXBuilt 1978 · S/N 18266352 N418MBRed Baron LLC · Dickinson, NDBuilt 1977 · S/N 18266154 N418SASummit Aviation Inc · Middletown, DEBuilt 1979 · S/N 18267433 N41GVRbs Inc · Wht Sphr Spgs, WVBuilt 1977 · S/N 18265837 N41JCKiddink LLC · Wilmington, DES/N 18267036 N41MQParsons Douglas L · Carrollton, OHBuilt 1978 · S/N 18266506 N41MTX2nsat Inc · Petaluma, CABuilt 1977 · S/N 18265725 N421TWHeslin Jon L · Sutton, MABuilt 1978 · S/N 18266268 N421YKearns Homer C III · Granbury, TXBuilt 1977 · S/N 18266133 N422JLeecorp Transport LLC · Naples, FLBuilt 1977 · S/N 18266172 N422SPCrosby Scott · Mauldin, SCBuilt 1978 · S/N 18266299 N425PRHorizon Technical Services Inc · Farmingdale, NYBuilt 1977 · S/N 18266202 N427WYMayes Neil M · Lovell, WYBuilt 1978 · S/N 18266557 N42RHGet-U-There Air LLC · Poplar Grove, ILBuilt 1979 · S/N 18266776 N430KUlve Scott David · Camdenton, MOBuilt 1979 · S/N 18267209 N432RRFirst Plane LLC · Erie, PAS/N 18267066 N43DEReynolds Carl R · Bryn Mawr, PABuilt 1977 · S/N 18266212 N43TJCyr Philip · Charlton, MABuilt 1979 · S/N 18267365 N441TJRylee LLC · Lawrence, KSBuilt 1979 · S/N 18267141 N4421UClaypool James W · Hunts Point, WABuilt 1980 · S/N 18267449 N442LHSkylane 182q LLC · Punta Gorda, FLBuilt 1980 · S/N 18267692 N4431VPeters Frank S · Aspen, COBuilt 1977 · S/N 18265958 N444GENeverland LLC · Emerson, IABuilt 1978 · S/N 18266675 N4468NN4468n LLC · Loganville, GAS/N 18267639 N449WAEuroaviation Inc Trustee · KamatenS/N 18266773 N44LUGresham Thomas H · Cascade, IDBuilt 1979 · S/N 18267355 N44TBPacific Horizon LLC · Eagle, IDS/N 18267207 N44XWMinnehan Land & Cattle · Joplin, MTS/N 18266990 N459THHlavaty Troy Edward · Columbus, NEBuilt 1980 · S/N 18267544 N4622NVmi Flight Co LLC · Roanoke, VABuilt 1979 · S/N 18267281 N4651NSuemac Farms LLC · Crawfordsville, ARS/N 18267284 N4660NCasey Kellie M DBA · Fort Worth, TXBuilt 1979 · S/N 18267285 N4690N4690n LLC · North Andover, MABuilt 1979 · S/N 18267289 N4692NWilliams Douglas J · Bristol, NHBuilt 1979 · S/N 18267290 N4697NWang Kun · Whitestone, NYS/N 18267291 N469DCLaw David L · Derby, KSBuilt 1979 · S/N 18266646 N4704NScott Lester N · Pleasanton, CAFirst renewal noticeBuilt 1979 · S/N 18267294 N4705NBrentco Aerial Patrol Inc · Canton, OHBuilt 1979 · S/N 18267295 N4706NReef Clipper LLC · Pittstown, NJS/N 18267296 N4707NBrandon Gregory R · Talking Rock, GAS/N 18267297 N4708NSkylane LLC · Billings, MTBuilt 1979 · S/N 18267298 N4714NOwen John E · Aiken, SCBuilt 1979 · S/N 18267303

Back to Cessna 182Q