Skip to content

Registered aircraft · 270

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

N8853XSnflk Leasing LLC · Andrews, TXBuilt 1961 · S/N 18253253 N8854XSuper Skylane LLC · Dewey, AZBuilt 1961 · S/N 18253254 N8857XBlanton Robert D · Wichita, KSBuilt 1961 · S/N 18253257 N8858XGordon Jeffrey · Indianapolis, INS/N 18253258 N8863XDupuis Logging Inc · Polson, MTBuilt 1961 · S/N 18253263 N8865XBeerman Paul L · Fort Wayne, INBuilt 1961 · S/N 18253265 N8869XAshley Heating And Air Conditioning · Wasilla, AKBuilt 1961 · S/N 18253269 N8871XRegistered aircraftBuilt 1961 · S/N 18253271 N8876XBowen Gabriel J · Salt Lake City, UTBuilt 1960 · S/N 18253276 N8879XKlingelhoffer Jeffrey A · Olympia, WABuilt 1961 · S/N 18253279 N8881XFluegel Justin D · Gresham, ORS/N 18253281 N8882XMyrtle Aviation Inc · Wichita, KSBuilt 1961 · S/N 18253282 N8884XMckinley Michael S · Florence, AZBuilt 1961 · S/N 18253284 N8891XHamilton Soaring Club Inc · Hamilton, TXS/N 18253291 N8892XBlinn Randy · Priest River, IDBuilt 1961 · S/N 18253292 N8894XRenfro Clinton G · Anchorage, AKBuilt 1961 · S/N 18253294 N8898XSargent Matthew M · Glenwood, IABuilt 1961 · S/N 18253298 N8899XJohnston Thomas D · Heyworth, ILBuilt 1961 · S/N 18253299 N8901XHilde Justin · Statesboro, GABuilt 1961 · S/N 18253301 N8903XGreene Bruce · Asheville, NCBuilt 1961 · S/N 18253303 N8904XPlanes Of Fame Air Museum · Chino, CABuilt 1961 · S/N 18253304 N8907XFrey Harlan Jerome · Carey, OHBuilt 1961 · S/N 18253307 N8909XHubbert Stephen B · Owasso, OKBuilt 1961 · S/N 18253309 N8910XElardi Frank Paul · Upland, CABuilt 1961 · S/N 18253310 N8912XAman Douglas A · Fairfield, ILBuilt 1961 · S/N 18253312 N8917XCleveland William B III · Canal Fulton, OHBuilt 1961 · S/N 18253317 N8918XRtillery Services LLC · Holdrege, NEBuilt 1961 · S/N 18253318 N8924XPrevo Jerry L · Anchorage, AKBuilt 1961 · S/N 18253324 N8925XMuetterties Eric Joseph · Dublin, CABuilt 1960 · S/N 18253325 N8927XSkydive Mid America LLC · Macon, MOS/N 18253327 N8929XDivan Jeremy · Castle Rock, COBuilt 1961 · S/N 18253329 N8931XBelding Kirk A · Grass Valley, CAS/N 18253331 N8933XSnyder Mark · Norwood, COBuilt 1961 · S/N 18253333 N8940XKish John · Fort Mohave, AZBuilt 1961 · S/N 18253340 N8941XParrish Perry W · Columbia, KYS/N 18253341 N8942XBlb Group LLC · Lake Havasu City, AZBuilt 1961 · S/N 18253342 N8945XHarty Arthur · Acampo, CABuilt 1961 · S/N 18253345 N8946XKennedy Dennis R Trustee · Westlake Village, CABuilt 1961 · S/N 18253346 N8947XN8947x LLC · Middletown, DEBuilt 1961 · S/N 18253347 N8948XRhodes Steven D · Anchorage, AKBuilt 1961 · S/N 18253348 N8950XAnderson Craig M · Barron, WIBuilt 1961 · S/N 18253350 N8953XHenning Jeffrey Carl · Prescott, AZBuilt 1961 · S/N 18253353 N8954XGansz Kenneth L · Clare, IABuilt 1961 · S/N 18253354 N8955XPampa Office Supply · Elk City, OKBuilt 1961 · S/N 18253355 N8956XLove Brandon · Big Sandy, TXS/N 18253356 N895UPFlying Frog Aviation LLC · Stillwater, MNBuilt 1961 · S/N 18253351 N8962XWb Aero LLC · Mountain Home, TXS/N 18253362 N8963XZimmermann Lukas · Tucson, AZBuilt 1961 · S/N 18253363 N8966XHotrod 182 LLC · Rayville, LABuilt 1961 · S/N 18253366 N8972XFoothills Aviation LLC · Buhl, IDBuilt 1961 · S/N 18253372

Back to Cessna 182D