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.

N124BSLeair LLC · Eufaula, ALBuilt 2004 · S/N 18281390 N124WJSessions Thomas Eric Trustee · Huffman, TXBuilt 2004 · S/N 18281475 N1251DErjoaero LLC · Stuart, FLBuilt 2007 · S/N 18282023 N125JABillmans Inc · Cut Bank, MTBuilt 2005 · S/N 18281527 N125SLSlingshot Aviation LLC · Chandler, AZBuilt 2003 · S/N 18281253 N12675Van Bortel Aircraft Inc · Arlington, TXBuilt 2007 · S/N 18282026 N127CFGeorgia Forestry Commission · Macon, GABuilt 2007 · S/N 18282027 N127SLGulf Coast Helicopters Inc · Pearland, TXBuilt 2003 · S/N 18281256 N1290FKilm LLC · Wilmington, NCBuilt 2007 · S/N 18282045 N129BAAdvise By Air LLC · Whittier, CABuilt 2004 · S/N 18281353 N12HPState Of Ohio · Columbus, OHBuilt 2002 · S/N 18281158 N1309MReny Donald Cyril Jr · League City, TXBuilt 2008 · S/N 18282050 N1341PN8075q LLC · Corpus Christi, TXBuilt 2007 · S/N 18281876 N13433Seamoose Aviation LLC · Shelton, CTBuilt 2007 · S/N 18281878 N1359BLagos Aero LLC · Houston, TXBuilt 2007 · S/N 18281880 N14007Kga Aviation LLC · Alfred, MEBuilt 2005 · S/N 18281589 N14205Dfi Aviation Services LLC · Herndon, VABuilt 2007 · S/N 18281889 N1420POrchid Aviation LLC · Palm Springs, CABuilt 2007 · S/N 18281888 N1424CGlendoe Inc Trustee · Wilmington, DEBuilt 2005 · S/N 18281610 N14297Barrett Eric W · Cherry Hill, NJBuilt 2005 · S/N 18281715 N142DLRoss Branta Enterprises · Boise, IDBuilt 2004 · S/N 18281470 N142LJObr Leasing · Bristow, VAFirst renewal noticeBuilt 2010 · S/N 18282272 N146FAcrehood Air LLC · St Augustine, FLBuilt 2004 · S/N 18281437 N1483L83l Ventures LLC · San Carlos, CABuilt 2007 · S/N 18281960 N1489LBusiness Mens Flying Club Inc · Naperville, ILBuilt 2007 · S/N 18281901 N1492UD & S Aviation LLC · Spring, TXBuilt 2007 · S/N 18281962 N1493RChaffin Alex · Fayetteville, ARBuilt 2005 · S/N 18281694 N1496CSbma Services LLC · Mcclellan, CABuilt 2005 · S/N 18281693 N149CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282190 N14QWDinucci Mario · Auburn, CABuilt 2006 · S/N 18281760 N151FCDepartment Of Agriculture And Consumer Services · Tallahassee, FLBuilt 2006 · S/N 18281874 N15242Bluclouds LLC · Kirkland, WABuilt 2005 · S/N 18281614 N152CFCharlie Fox LLC · Wilmington, DEBuilt 2002 · S/N 18281074 N152CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282335 N153FCDepartment Of Agriculture And Consumer Services · Tallahassee, FLBuilt 2006 · S/N 18281774 N153TAAmerican Eagle 1 LLC · Kimberling City, MOBuilt 2001 · S/N 18281053 N154FCDepartment Of Agriculture And Consumer Services · Tallahassee, FLBuilt 2006 · S/N 18281785 N155FCState Of Florida · Tallahassee, FLBuilt 2006 · S/N 18281789 N157CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281857 N157FCDepartment Of Agriculture & Consummer Services · Tallahassee, FLBuilt 2006 · S/N 18281875 N158CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281858 N158CWMcdonald John C · Hallsville, TXBuilt 2004 · S/N 18281381 N158FCDept Of Agriculture & Consumer Services · Tallahassee, FLBuilt 2008 · S/N 18282062 N159CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281859 N159FCDept Of Agriculture & Consumer Services · Tallahassee, FLBuilt 2008 · S/N 18282065 N164BDRuffin Robert L Jr · Mabank, TXBuilt 2004 · S/N 18281459 N164CWMudd Joe · Tucson, AZBuilt 2004 · S/N 18281325 N165CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281865 N167LPSymanowski Kevin L · Reeder, NDBuilt 2001 · S/N 18281067 N168CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282336

Back to Cessna 182T