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.

N735VAWaggoner David F Trustee · Aurora, ORS/N 18265708 N735VBShogry Louis M III · Lee, MAS/N 18265709 N735VCTalbott Tom · Tempe, AZBuilt 1977 · S/N 18265710 N735VFSheffels James · Great Falls, MTBuilt 1977 · S/N 18265713 N735VHKcsi Aerial Patrol Inc · Bakersfield, CAS/N 18265715 N735VKWelge Jack H Jr · Longview, TXBuilt 1977 · S/N 18265717 N735VLAnderson William R · Overland Park, KSBuilt 1977 · S/N 18265718 N735VMMorris Dale L · Yelm, WABuilt 1977 · S/N 18265719 N735VPMpc Aviation LLC · Homestead, FLBuilt 1977 · S/N 18265721 N735VSFrench Steve · Jupiter, FLBuilt 1977 · S/N 18265724 N735VVBw LLC · Denver, COBuilt 1977 · S/N 18265727 N735VXRicupero Gary T Trustee · Monterey, CAS/N 18265729 N735WAPiro Anthony Michael · Groveland, CABuilt 1977 · S/N 18265732 N735WGWilliford Jason R · Randlett, OKBuilt 1977 · S/N 18265738 N735WHTwining David S · Corvallis, ORBuilt 1977 · S/N 18265739 N735WKRomper Aviation LLC · Boise, IDBuilt 1977 · S/N 18265741 N735WLScott Lindsey · Toledo, WABuilt 1977 · S/N 18265742 N735WMHolland John E Trustee · Sharon Center, OHS/N 18265743 N735WRHuizenga Bruce A · Waupun, WIS/N 18265747 N735WTBlack Timber Industrial LLC · Silt, COBuilt 1977 · S/N 18265749 N735WUCarter Gary James · Manlius, NYBuilt 1977 · S/N 18265750 N735XEMant Thomas A · Diamond Springs, CABuilt 1977 · S/N 18265760 N735XFAlabama Aircraft Management LLC · Valley Head, ALBuilt 1977 · S/N 18265761 N735XHTippair Inc · West Lafayette, INBuilt 1977 · S/N 18265763 N735XMHansen Michael J · Marysville, WABuilt 1977 · S/N 18265767 N735XSCarbajal Juan Luis Sr · Gualala, CABuilt 1977 · S/N 18265772 N735XTVentura Aviation LLC · Emerald Isle, NCBuilt 1977 · S/N 18265773 N735XZRegistered aircraftS/N 18265779 N735YAMinnillo Vincent C · Ocala, FLBuilt 1977 · S/N 18265780 N735YBRaulerson James · Holland, MOBuilt 1977 · S/N 18265781 N735YCLindsay Stephen J · Middletown, NYBuilt 1977 · S/N 18265782 N735YGGiacomet Mauro · Portage, MIBuilt 1977 · S/N 18265786 N735YJDuluth Ang Flying Club Inc · Cloquet, MNBuilt 1977 · S/N 18265788 N735YLBlue Skies Aviation LLC · Lansing, MIBuilt 1977 · S/N 18265790 N735YRGibbs Phillip G · Dubuque, IABuilt 1977 · S/N 18265795 N735YTVenturini Renato A Jr · Friendswood, TXBuilt 1977 · S/N 18265797 N735YUObrien Daniel Joseph · Woburn, MABuilt 1977 · S/N 18265798 N735YVSmith Gary L Sr · Monrovia, MDBuilt 1977 · S/N 18265799 N735YWKershner William C · Sewanee, TNBuilt 1977 · S/N 18265800 N735YXKrm Aviation LLC · Dahlonega, GABuilt 1977 · S/N 18265801 N735YYR & B Aviation LLC · Rogers, ARBuilt 1977 · S/N 18265802 N735YZChism Benjamin H · Elk City, KSBuilt 1977 · S/N 18265803 N735ZAHine Butler · Los Altos, CABuilt 1977 · S/N 18265804 N735ZBCarroll Robert Douglas Jr · Moab, UTS/N 18265805 N735ZDLansink Ronald L Trustee · Danbury, IABuilt 1977 · S/N 18265807 N735ZFKatsinis James N · AthensNon-citizen corporation, flight hours not reportedS/N 18265809 N735ZHWonder Lake Flying Club Inc · Wonder Lake, ILBuilt 1977 · S/N 18265811 N735ZKFine Frank E · Oakdale, CAS/N 18265813 N735ZNBerquist Harold J · Loveland, COBuilt 1977 · S/N 18265816 N735ZPThornton Allan F · Norfolk, VABuilt 1977 · S/N 18265817

Back to Cessna 182Q