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.

N447CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282353 N451BA1928 LLC · Salmon, IDBuilt 2005 · S/N 18281645 N451CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282194 N452CPCivil Air Patrol · Montgomery, ALBuilt 2013 · S/N 18282368 N455CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282196 N455HSSagnieres Hubert · Newport, VTBuilt 2001 · S/N 18281054 N458CDDiacont Charles R · Nazareth, PABuilt 2003 · S/N 18281231 N458WCSee Forever Holdings LLC · Wilmington, DEBuilt 2010 · S/N 18282235 N45ERWindmark Ridge LLC · Port Saint Joe, FLBuilt 2004 · S/N 18281498 N461AJRkt Productions · Bristow, VABuilt 2010 · S/N 18282225 N462JBPlane Nonsense Inc · Middletown, DEBuilt 2004 · S/N 18281362 N467TSPsl Surveys · Manassas, VABuilt 2010 · S/N 18282239 N468HN1694l LLC · Wilmington, DEBuilt 2004 · S/N 18281346 N469TCEast Pole Aviation LLC · E Setauket, NYBuilt 2001 · S/N 18280989 N46EFPringle Dan · Charlestown, INS/N 18280992 N470PGreentree Aviation LLC · Sewell, NJBuilt 2004 · S/N 18281290 N472WCJoe Morten & Son Inc · South Sioux City, NEBuilt 2002 · S/N 18281156 N478GPGypsy Aviation LLC · Hattiesburg, MSBuilt 2005 · S/N 18281523 N478MCDouble Eagle Air LLC · Searcy, ARBuilt 2005 · S/N 18281578 N481CPBlue Water Aviation LLC · Oakman, ALBuilt 2008 · S/N 18282048 N482CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282142 N482CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N 18282263 N486CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N 18282261 N486TCMonte D Burke · Dallas, TXBuilt 2004 · S/N 18281446 N490CPCivil Air Patrol · Maxwell Afb, ALBuilt 2010 · S/N 18282205 N490LLAntel Av Corp · Lewes, DEBuilt 2004 · S/N 18281432 N4925QEsty Effew LLC · Wimberley, TXBuilt 2012 · S/N 18282326 N493CPCivil Air Patrol · Maxwell Afb, ALBuilt 2010 · S/N 18282265 N495MCC182t LLC · Chattanooga, TNBuilt 2007 · S/N 18281895 N495WWNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282170 N499ETQualitair LLC Owner Trustee · MichesltadtBuilt 2006 · S/N 18281808 N4RGMayer Gordon · Dallas, TXBuilt 2002 · S/N 18281086 N50504Baker Merlin K · Bradford, OHBuilt 2001 · S/N 18281057 N507PHocker Matthew Tutt · LondonBuilt 2001 · S/N 18281008 N5100XSmith Ronald N · College Station, TXBuilt 2001 · S/N 18281063 N5101UMichigan Department Of Natural Resources · Roscommon, MIBuilt 2009 · S/N 18282156 N510KSNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282177 N510SLBeery Roofing & Redesign LLC · Deland, FLS/N 18282153 N510TRAltamira Flying Club Inc · Round Rock, TXBuilt 2003 · S/N 18281200 N51198Registered aircraftBuilt 2002 · S/N 18280990 N513MCWilliams Val · Victor, IDBuilt 2006 · S/N 18281811 N5141JSasser Nancy Elizabeth · Petaluma, CABuilt 2001 · S/N 18281062 N5141YCommonwealth Of Virginia · Fort Monroe, VABuilt 2002 · S/N 18281077 N514HPState Of Ohio / Department Of Public Safety · Columbus, OHBuilt 2005 · S/N 18281651 N514MRDmc Holdings LLC · Bullard, TXBuilt 2012 · S/N 18282328 N514NYJones Christopher S · Twin Falls, IDBuilt 2010 · S/N 18282271 N5164FBarr Air Patrol LLC · Mesquite, TXBuilt 2002 · S/N 18281082 N5166YSchmenk Brent · Frisco, TXBuilt 2002 · S/N 18281089 N51732Imsar LLC · Springville, UTBuilt 2002 · S/N 18281088 N5175PSbkr LLC · Greenville, PABuilt 2002 · S/N 18281155

Back to Cessna 182T