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.

N661SFSierra Foxtrot Ltd · Glen Ellyn, ILBuilt 1979 · S/N 18267049 N666WPHamilton Stuart E · Covington, GABuilt 1979 · S/N 18266914 N667ARRegistered aircraftBuilt 1977 · S/N 18265379 N66MJUnited States Air Force (Owner) · Usaf Academy, COS/N 18266399 N671PMBarron Bradley C · Harper, TXBuilt 1979 · S/N 18267475 N672DMWoodland Works Inc · Buena Vista, GABuilt 1977 · S/N 18265855 N678JBSierra Flyers Inc · Incline Village, NVBuilt 1980 · S/N 18267541 N679UPBrooke Enterprises LLC · Norco, CABuilt 1978 · S/N 18266598 N68EPSchwab William J Jr · Haltom City, TXBuilt 1979 · S/N 182-66889 N68PLBluebird Aviation LLC · Spokane, WABuilt 1979 · S/N 18266812 N691TTWhitfield Timothy D · Fairfield, NCS/N 18267038 N69TRZg Ltd · Green Cove Springs, FLBuilt 1977 · S/N 18265513 N6CRJ R Systems LLC · Kenedy, TXBuilt 1977 · S/N 18266190 N6DRHiggins Robert DBA · Gill, MABuilt 1979 · S/N 18266779 N6KKUey Aviation Group LLC · Newtown, CTBuilt 1979 · S/N 18267153 N6MAShewmaker Air LLC · Bentonville, ARBuilt 1979 · S/N 18267389 N6URAvidyne Corp · Melbourne, FLBuilt 1978 · S/N 18265967 N700PDAero Survey LLC · Lake Havasu City, AZBuilt 1979 · S/N 18266974 N700RWWhittington Rankin A Trustee · Lenoir, NCBuilt 1978 · S/N 18266323 N7048HMuise Jason A · Windham, NHS/N 18265754 N704AMAmerican Resources Inc · Harlan, KYS/N 18265979 N70GJOzark Airworks Inc · Midway, ARBuilt 1979 · S/N 18267177 N710GHAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1979 · S/N 18267470 N715MASim International Inc · Fort Mill, SCBuilt 1980 · S/N 18267469 N7182QMullins Albert A · Boling, TXS/N 18267345 N718JSBrewster Scott · Sedona, AZS/N 18265417 N71JTJav Air Services LLC · Anchorage, AKBuilt 1978 · S/N 18266696 N71KFFoster Kenneth B · Queen Creek, AZBuilt 1977 · S/N 18265723 N71MJ1mj LLC · Willis, TXBuilt 1979 · S/N 18267250 N71STGreen Martin H · Framingham, MABuilt 1978 · S/N 18266651 N721AEmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 1978 · S/N 18266259 N723DMCaswell & Sons LLC · Belmont, NCBuilt 1977 · S/N 18266076 N723NETaft Millens W III Trustee · Wilton, CTBuilt 1980 · S/N 18267616 N723SSTomlinson Jason R · Lake Jackson, TXBuilt 1979 · S/N 18267193 N724DBRegistered aircraftBuilt 1977 · S/N 18266198 N725ASGeorgia Co Of Aspiring Flyers LLC · Clarkesville, GABuilt 1978 · S/N 18266640 N727LSScarsella Luciano S · Lafayette, LAS/N 18265755 N727PCPb&J Holding LLC · Franktown, COBuilt 1979 · S/N 18267396 N728EGGarner John · Springfield, MOBuilt 1977 · S/N 18265842 N730AKMcmullen Michael J · Columbia, SCBuilt 1977 · S/N 18265482 N730LCJones Christopher N · Edgewood, WABuilt 1979 · S/N 18267417 N731MCFalk Arthur J · Southport, NCS/N 18265598 N73211Tc International Inc · Whittier, CABuilt 1978 · S/N 182-66301 N735AAKnight Kevin D · Hereford, TXBuilt 1976 · S/N 18265260 N735ABPapalote Ranches LLC · Missoula, MTBuilt 1976 · S/N 18265261 N735ACKempton Larry G Jr · Grand Junction, COBuilt 1976 · S/N 18265262 N735ADMassery Dean P · Lake Milton, OHBuilt 1976 · S/N 18265263 N735AFJanssen Rod · Beaufort, SCBuilt 1976 · S/N 18265265 N735AHMark R Cooper Aviation LLC · Fort Wayne, INBuilt 1976 · S/N 18265267 N735AKKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1976 · S/N 18265269

Back to Cessna 182Q