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.

N845PCPrecision Design Inc · Wilmington, DEBuilt 1973 · S/N 18262454 N84635Polly P LLC · Fort Worth, TXBuilt 1973 · S/N 18261888 N84672Registered aircraftBuilt 1973 · S/N 18261891 N8470MNorthwoods Aviation Inc · Cadillac, MIBuilt 1976 · S/N 18264615 N84724Iron Gate Farms LLC · Powhatan, VAS/N 18261893 N84731Weir Engineers LLC · Amherst, NHBuilt 1973 · S/N 18261896 N8479MFentress Philip W · Memphis, TNBuilt 1976 · S/N 18264617 N8480MCooper Keith L · Arvada, COBuilt 1976 · S/N 18264618 N8482MBuck Carl R · Highland Village, TXFirst renewal noticeBuilt 1976 · S/N 18264620 N8485MFriday Harbor Wings LLC · Friday Harbor, WABuilt 1976 · S/N 18264623 N8486MSatsang Air LLC · Monterey, CAS/N 18264624 N8488MMedia Stew LLC · Carson City, NVBuilt 1976 · S/N 18264626 N8489MOconnell Timothy Ryan · Davenport, WAS/N 18264627 N8493MValiair Lc Trustee · Casper, WYBuilt 1976 · S/N 18264629 N8494MCardinal Sg LLC · Mukilteo, WABuilt 1976 · S/N 18264630 N8499MCornale Michael J · Dwight, ILBuilt 1976 · S/N 18264632 N84DMGafni Tal · Scottsdale, AZBuilt 1973 · S/N 18262010 N84LSBrenberger Mark L · Raleigh, NCBuilt 1976 · S/N 18264741 N85074Patriot Pole Aviation LLC · Missouri Valley, IABuilt 1975 · S/N 18263614 N85892Vincent Mark · Concord, MABuilt 1973 · S/N 18261901 N85936Gm Aviation LLC · Baytown, TXS/N 18261904 N85938Urban Performance · Newark, OHBuilt 1973 · S/N 18261905 N85988Wilson Miles · Mcminnville, TNBuilt 1973 · S/N 18261907 N85ACSusten LLC · Austin, TXBuilt 1975 · S/N 18264232 N85EFRegistered aircraftBuilt 1974 · S/N 18263109 N85VBRegistered aircraftS/N 18263905 N86092Hubler Brian E · Paxinos, PABuilt 1973 · S/N 18261910 N86102Arrigo Aviation LLC · Erie, COBuilt 1973 · S/N 18261912 N86167Jonsplain LLC · San Angelo, TXBuilt 1973 · S/N 18261916 N86168Mmm Aviation LLC · Scottsdale, AZBuilt 1973 · S/N 18261917 N86227Kantorowicz Tammy · Great Falls, MTBuilt 1973 · S/N 18261919 N86261Odle Scott Thomas · Redmond, WABuilt 1973 · S/N 18261922 N86289Hudec John S · Crown Point, INBuilt 1973 · S/N 18261923 N86354White Billy C · Crestview, FLBuilt 1973 · S/N 18261928 N86438Walleman Benjamin · Macomb, MIBuilt 1973 · S/N 18261933 N86450Butte Flying Club Inc · Chico, CABuilt 1973 · S/N 18261937 N86510Ungersma Thomas Robert · Belgrade, MTBuilt 1973 · S/N 18261938 N86526Hill Farms Inc · Drexel, MOBuilt 1973 · S/N 18261941 N86536Moes Crop Dusting Service Inc · Marysville, CABuilt 1973 · S/N 18261942 N86541Hyppa Russell F · Cook, MNFirst renewal noticeBuilt 1973 · S/N 18261943 N86AQTwo Js Aviation LLC · Moses Lake, WAS/N 18261787 N86EBBannen Edward · Westerville, OHBuilt 1975 · S/N 18263675 N8768MRegistered aircraftBuilt 1976 · S/N 18264636 N877CBNagaruk Nathan · Nome, AKBuilt 1974 · S/N 18263528 N87KKBowcon Inc · Minooka, ILBuilt 1976 · S/N 18264839 N880LSYoshitomi Chad M · Anchorage, AKBuilt 1976 · S/N 18265073 N888CTNorthland Beverage Inc · Flagstaff, AZBuilt 1975 · S/N 182-64107 N888CZPhotos Unlimited · Rancho Cordova, CABuilt 1974 · S/N 18263472 N888SPHelsing Roy · Little River, CABuilt 1973 · S/N 18262456 N889BABarr Air Patrol LLC · Mesquite, TXBuilt 1972 · S/N 18261204

Back to Cessna 182P