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.

N759YURegistered aircraftBuilt 1978 · S/N 18266372 N759YWChamberlain Diane L · Houston, TXS/N 18266374 N759YXMagee Thomas J · Pasadena, CABuilt 1978 · S/N 18266375 N759YYWainwright LLC · Mesa, AZFirst renewal noticeS/N 18266376 N759ZDN759zd LLC · Stratford, CTBuilt 1978 · S/N 18266381 N759ZETransair Leasing Inc · Miami, FLBuilt 1978 · S/N 18266382 N759ZHHatch George R · Avon, MABuilt 1978 · S/N 18266385 N759ZKShelley James R · Bowling Green, KYBuilt 1978 · S/N 18266387 N759ZMN759zm LLC · Fort Collins, COBuilt 1978 · S/N 18266389 N759ZQSlone Bryan E · Omaha, NEBuilt 1978 · S/N 18266392 N759ZTSherck Nicholas · Woodbridge, NJBuilt 1978 · S/N 18266395 N759ZUFlying Bobcat LLC · Boise, IDS/N 18266396 N75WGHenry David Greer Sr · Waco, TXBuilt 1978 · S/N 18266297 N7602SLarson Peter M Trustee · Antioch, ILBuilt 1976 · S/N 18265250 N7603SBobcat Trucking Inc · New Braunfels, TXBuilt 1976 · S/N 18265251 N7604SCloud Nine Management LLC · Orlando, FLBuilt 1976 · S/N 18265252 N7605SAdco Land Corp · Richmond, VABuilt 1976 · S/N 18265253 N7606SAnthony Judith A Trustee · Kerrville, TXBuilt 1976 · S/N 18265254 N7607SBelle Valle Aviation LLC · St Petersburg, FLBuilt 1978 · S/N 18265255 N7608SMkc Flying LLC · Gladstone, MOBuilt 1976 · S/N 18265256 N7609SButzbaugh Elden W Jr · Saint Joseph, MIBuilt 1976 · S/N 18265257 N7611SMile High Advertising Inc · Doylestown, PABuilt 1976 · S/N 18265259 N765SRRichard Stephen R · Delphos, KSBuilt 1979 · S/N 18267164 N769DBLeblanc Alissa Walton · Dickinson, TXBuilt 1979 · S/N 18267001 N76DLSpur-N-Rotor Inc · Great Falls, MTBuilt 1978 · S/N 18266298 N77182Magro Daniel L Sr · Piperton, TNS/N 182-65921 N772TXDyson Thornton E · Houston, TXBuilt 1979 · S/N 18267491 N777KSBrahm Robert D · Mercer Island, WABuilt 1978 · S/N 18266736 N777TVTop Ag Inc · Colby, KSBuilt 1977 · S/N 18265360 N77GZImpact 4 Christ Ministries · Crescent City, CABuilt 1977 · S/N 18265460 N77SYOlson Michael A · Londonderry, VTBuilt 1977 · S/N 18265626 N782CB182q LLC · Anthem, AZBuilt 1979 · S/N 18267192 N784GHenry Frank P · Winnabow, NCBuilt 1977 · S/N 18265960 N784LMNorth Lake Air LLC · Lindstrom, MNBuilt 1979 · S/N 18267452 N785BKPilot Peak Aviation LLC · Kalispell, MTBuilt 1977 · S/N 18265768 N787DCChavers Seaborn W Jr · Stamping Ground, KYBuilt 1980 · S/N 18267611 N787DDHyde James C · Clifton, VABuilt 1977 · S/N 18265896 N789DMAllen Gary D · Eyota, MNS/N 18266555 N78LHL & J Adventures LLC · Paris, OHBuilt 1978 · S/N 18266426 N78WRSwift Aviation LLC · Lampasas, TXBuilt 1977 · S/N 18265385 N7922CKemmax Holdings LLC · Latham, NYBuilt 1978 · S/N 18266633 N799BSBlue Sky Aviation LLC · Clarksburg, MDBuilt 1979 · S/N 18267293 N79CDMcvay E Howard Jr · Riverside, RIBuilt 1979 · S/N 18266793 N79JPErickson James · Wasilla, AKBuilt 1979 · S/N 18267081 N79TRWallace Ronald J · Santa Teresa, NMBuilt 1979 · S/N 18267136 N79WGSmith Ryan · Leawood, KSBuilt 1980 · S/N 182-67585 N7RABeck James E · Palacios, TXBuilt 1979 · S/N 18266880 N7RVHartzell Joseph J · GrandvauxBuilt 1979 · S/N 18267435 N800HPSanders George W Jr · Cloverdale, INFirst renewal noticeBuilt 1979 · S/N 18266903 N800WEOptic Air LLC · Maurice, IABuilt 1979 · S/N 18267408

Back to Cessna 182Q