Skip to content

Registered aircraft · 969

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 ('2072703', '2072707', '2072705')
  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 ('2072703', '2072707', '2072705')
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.

N232ZVance Jordan Enterprises Inc · Wilmington, DEBuilt 2005 · S/N 18281627 N234LPDethloff Joseph · St Johns, FLS/N 18281047 N2350HRieder John · Camarillo, CABuilt 2005 · S/N 18281706 N2351EHog Aviation LLC · Fort Smith, ARBuilt 2005 · S/N 18281707 N237CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282348 N237FBGomez Preston Andreas · Bismarck, NDBuilt 2007 · S/N 18281916 N23959State Of Wisconsin · Madison, WIBuilt 2006 · S/N 18281748 N2396KWhitley Pat · Altoona, ALBuilt 2006 · S/N 18281750 N23TLLottman Aviation LLC · Beatrice, NEBuilt 2004 · S/N 18281503 N23YPBmf Jax LLC · Jacksonville, FLS/N 18281468 N2401AWhite Pat J · Wellington, TXBuilt 2006 · S/N 18281755 N2405SJohn L Lyle Aviation LLC · Ridgeland, MSBuilt 2006 · S/N 18281759 N240DCWestbank Fishing LLC · Kiln, MSBuilt 2002 · S/N 18281099 N241AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281182 N24201Suhr Douglas Henry Jr · Oil City, PABuilt 2007 · S/N 18281954 N242AFAlagar Volare LLC · Anna, TXBuilt 2003 · S/N 18281183 N2436VGt Holdings LLC · Nashville, TNBuilt 2006 · S/N 18281786 N2437LLean Enterprises Inc · Brookhaven, MSBuilt 2006 · S/N 18281791 N2438AHorse Creek 3518 Inc · Hollywood, FLBuilt 2006 · S/N 18281793 N2438FMackie Scott Christopher · Elkton, MDBuilt 2006 · S/N 18281794 N2439BVan Bortel Aircraft Inc · Arlington, TXBuilt 2001 · S/N 18280955 N2441XPippy LLC · Naples, FLBuilt 2006 · S/N 18281802 N24440Stikes Aviation LLC · Griffin, GABuilt 2001 · S/N 18280956 N2445RVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 18281720 N2449TElevation Club Air LLC · Hunting Valley, OHBuilt 2005 · S/N 18281727 N2451HBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 18280950 N2451ZMasciola Michael J · Dunn Loring, VABuilt 2001 · S/N 18280949 N2454GBender Brian · Park City, UTFirst renewal noticeBuilt 2005 · S/N 18281725 N2455UVertol Systems Co Inc · Destin, FLBuilt 2005 · S/N 18281726 N2456MBarta Michael D · Hilton Head Island, SCBuilt 2007 · S/N 18281956 N2456VPremier Flight Solutions LLC · Orlando, FLBuilt 2006 · S/N 18281763 N2457CMorris Velma L · Visalia, CAS/N 18280947 N2460GVan Bortel Aircraft Inc · Arlington, TXBuilt 2007 · S/N 18281957 N2462PSan Diego Aviation LLC · San Diego, CABuilt 2005 · S/N 18281733 N2463BMichigan Dept Of Natural Resources · Roscommon, MIBuilt 2005 · S/N 18281735 N2463SNjnj Aviation LLC · Belmont, CABuilt 2005 · S/N 18281738 N24673R66 And Cattle LLC · Southlake, TXBuilt 2006 · S/N 18281745 N246CGDickerson Realty Corp · Charlotte, NCS/N 18281485 N2474CArchitectural Industrial Rentals LLC · Wilmington, DEBuilt 2001 · S/N 18280978 N2474NWestbank Fishing LLC · Kiln, MSS/N 18280980 N252AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281185 N259CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282349 N25HPFlorida Highway Patrol · Tampa, FLBuilt 2006 · S/N 18281842 N261AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281186 N261CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282136 N262AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281187 N262CLGiga Energy Inc · Buna, TXBuilt 2004 · S/N 18281497 N267RHPxw Services · Bristow, VABuilt 2010 · S/N 18282208 N2682CInternational Air Services Inc Trustee · Carson City, NVS/N 18281648 N269SFlightco Inc · Swainsboro, GABuilt 2001 · S/N 18281061

Back to Cessna 182T