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.

N562SVAv8tr Holdings LLC · Kent, NYBuilt 1978 · S/N 18266238 N5648JSswb Enterprises LLC · Lufkin, TXBuilt 1974 · S/N 18263479 N566JCMurphy Janel L · Lake Lure, NCBuilt 1977 · S/N 18265541 N566RMBueter Eric · Wauseon, OHBuilt 1977 · S/N 18265722 N567DGFrederick Investment Corp · Raleigh, NCBuilt 1979 · S/N 18266870 N567SDBordett Jason Scott · Palm Beach Gardens, FLBuilt 1979 · S/N 18267477 N568WCormell Eric M · Caldwell, IDBuilt 1979 · S/N 18266813 N577CTShaw Air Limited LLC · Mansfield, PAS/N 18266546 N577TCCrimson Aviation LLC · Helena, MTBuilt 1980 · S/N 18267564 N57BRRamsey Brent C · Tulsa, OKBuilt 1979 · S/N 18267277 N57DLGarrett Gary M · Reno, NVBuilt 1978 · S/N 18266366 N57PHEldredge Bradley P · Highland, UTS/N 18265514 N5858TAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 18266683 N5868MMack Michael J · Loomis, CABuilt 1977 · S/N 18266083 N587BCBlacow Kenneth Michael · Key West, FLBuilt 1979 · S/N 18267419 N58DWWilson Daniel J · Mount Vernon, OHBuilt 1979 · S/N 18267139 N58RRClover Management Systems Inc · Sanford, FLBuilt 1980 · S/N 18267545 N5943GFlight Express LLC · Henry, TNBuilt 1979 · S/N 18266907 N5946JMillett Paul B · Claremore, OKBuilt 1979 · S/N 18267024 N596DLCrater Lake Leasing LLC · Las Vegas, NVBuilt 1977 · S/N 18265642 N5HRRay Tanner Motors Inc · Phoenix, AZFirst renewal noticeBuilt 1980 · S/N 18267523 N5PCKeck Kevin W Trustee · Meridian, IDBuilt 1977 · S/N 18265656 N5ZZLeirer Von O · Los Gatos, CABuilt 1977 · S/N 18265840 N600HBCoastal Aerops LLC · Montrose, ALBuilt 1978 · S/N 18266490 N602SFOffut Ancel M Jr · Madison, ALBuilt 1980 · S/N 18267575 N605PMSky Baja LLC · Helena, MTS/N 18267188 N606TXF-22 LLC · Danbury, TXBuilt 1978 · S/N 18266763 N608FGWilliam J Taylor Aviation LLC · Kendallville, INBuilt 1979 · S/N 18266913 N610MVCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 18267413 N610SLTen Hi Flyers Inc · Denver, COS/N 18267376 N611SAAda Forestry Division · Malvern, ARBuilt 1976 · S/N 18265295 N613AKNorman Scott E · Anchorage, AKBuilt 1976 · S/N 18265221 N613TLSams Aircraft LLC · Fredonia, KYBuilt 1980 · S/N 18267613 N616PJLarson Paul S · San Carlos, CABuilt 1979 · S/N 18267121 N61705White Robert Tyler · Pleasanton, CABuilt 1977 · S/N 18265728 N6185FLyford Charles A IV · Bellevue, WABuilt 1977 · S/N 18265984 N618MKRegistered aircraftBuilt 1978 · S/N 18266388 N61ELMartinez Del Sobral Luisa Del Carmen Romero · Justin, TXBuilt 1979 · S/N 18267058 N6215BArtskills Inc · Bethlehem, PABuilt 1977 · S/N 18266135 N621SJAirmax Internet LLC · Troutman, NCBuilt 1979 · S/N 18267372 N624MAurora Aviation LLC · Delray Beach, FLBuilt 1978 · S/N 18266624 N626DTA & F Aviation Services LLC · Collierville, TNBuilt 1979 · S/N 18266784 N627PL8s1-51 LLC · Polson, MTS/N 18265311 N630ATAir Tiger LLC · Eunice, LAS/N 18267075 N634NCN634nc LLC · Apopka, FLBuilt 1977 · S/N 18266008 N635CGLongstreth James E · Powhatan, VAS/N 18265386 N641ABDaccarett Marcos · Boise, IDS/N 182-67178 N641TAAk Leasing LLC · Orchard Lake, MIBuilt 1978 · S/N 18266599 N648BDHansen Robert C · Delavan, WIBuilt 1978 · S/N 18266461 N658BWKatmai 658bw LLC · Sun Valley, IDBuilt 1980 · S/N 18267669

Back to Cessna 182Q