Skip to content

Registered aircraft · 606

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

N101VBRegistered aircraftBuilt 1999 · S/N 18280438 N102MASquaw Creek Aviation LLC · Dover, DES/N 18280100 N103NCState Of North Carolina · Raleigh, NCBuilt 1999 · S/N 18280647 N104ABPeterson Kevin D · Peoria, AZBuilt 1998 · S/N 18280280 N107PFConant Dakotah · Ocala, FLBuilt 1998 · S/N 18280220 N108PFKeith Wilcox & Sons Inc · Rexburg, IDBuilt 1998 · S/N 18280092 N10AVMaak Holdings LLC · Missoula, MTBuilt 1999 · S/N 18280129 N115PFHigh Tech Metals Inc · Harrisburg, PABuilt 1998 · S/N 18280224 N116VGBruns Phillip T · Shiro, TXBuilt 1998 · S/N 18280346 N116WBDunch David J Trustee · Poland, OHBuilt 1998 · S/N 18280170 N116ZXVranjes Peter · Johnstown, COBuilt 1997 · S/N 18280042 N117SDLong Joseph F · Carroll, OHS/N 18280926 N1190DCds Enterprise Group LLC · Ionia, MIBuilt 2000 · S/N 18280694 N120GRStarlight Flight Aerial Tours LLC · Coppell, TXBuilt 1999 · S/N 18280430 N122DTFine Point Aviation LLC · Carrollton, GABuilt 2000 · S/N 18280908 N123ARRullan Alberto · Adjuntas, PRBuilt 1998 · S/N 18280232 N124EFGuerrer Daniel S · Redondo Beach, CABuilt 1998 · S/N 18280315 N1252EStedje Timothy M · Gruver, TXBuilt 1999 · S/N 18280580 N125LGWheat Travis W · Henderson, NVS/N 18280070 N125WWKapotes Nicholas Stephan · Pompton Plains, NJBuilt 1998 · S/N 18280348 N129SEBarrington Air Inc · Littleton, COBuilt 1998 · S/N 18280384 N12EEArizona Cloudbusters Inc · Mesa, AZS/N 18280038 N130MEPetersens Marine Services Corp · Ridge, NYBuilt 2000 · S/N 18280686 N132MEPena Jairo · Catharpin, VABuilt 2000 · S/N 18280690 N134DBBlue Skies27 LLC · Los Angeles, CABuilt 2000 · S/N 18280808 N139RABeach Cruisers LLC · Ormond Beach, FLBuilt 1999 · S/N 18280614 N146NEAngle Mark W · Lake Orion, MIBuilt 1998 · S/N 18280221 N146WHAmick Ralph O · Hatteras, NCS/N 18280304 N148SMSarasota Westwind Flyers Inc · Sarasota, FLS/N 18280040 N149MEMccrary Mike M · Fairhope, ALBuilt 2000 · S/N 18280721 N151BSEvans Linda J · North Wales, PABuilt 2001 · S/N 18280934 N151MELoweth William A · Noank, CTBuilt 2000 · S/N 18280722 N152MEChamp Jerry D · Belton, SCBuilt 2000 · S/N 18280723 N157RDBoman & Kemp Lc · Ogden, UTBuilt 1999 · S/N 18280646 N157SMHumphreys James F · Charleston, WVBuilt 1998 · S/N 18280157 N157ZZRegistered aircraftS/N 18280402 N158JRCollins Stephen Neil · Clancy, MTS/N 18280051 N159DRPiedmont Flight Inc · Winston Salem, NCBuilt 1998 · S/N 18280128 N162CSFrielingsdorf Tim Richard · Manvel, TXBuilt 1998 · S/N 18280192 N162TCDrummond E Garrison · Parksley, VABuilt 1998 · S/N 18280164 N163JBBender W Jeffrey · Ocala, FLBuilt 2000 · S/N 18280715 N164SJFriedman Matthew · Herndon, VABuilt 1997 · S/N 18280064 N168DSVertx Fleet Holdings LLC · San Diego, CABuilt 1997 · S/N 18280032 N171STDkg Motorized Conveyances Inc · Beaverton, ORBuilt 2000 · S/N 18280703 N1737STms Aviation Inc · Wilmington, DEBuilt 2000 · S/N 18280763 N1823CA&E Flying Club Of Los Angeles · Hawthorne, CABuilt 1998 · S/N 18280171 N1828MCampbell Larry Lance · White Lake, MIBuilt 2000 · S/N 18280893 N182ABFoyhwg Inc · Holbrook, NYS/N 18280023 N182AMScavella George A Jr · Hauppauge, NYBuilt 1998 · S/N 18280116 N182CKDowning Richard C · Arlington, TXBuilt 1997 · S/N 18280018

Back to Cessna 182S