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.

N783CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281783 N784DRMyren Jason A · Marion, IABuilt 2003 · S/N 18281213 N787MDGeorgia Forestry Commission · Macon, GABuilt 2011 · S/N 18282308 N788CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281777 N788RMVan Bortel Aircraft Inc · Arlington, TXBuilt 2012 · S/N 18282321 N794CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282127 N796HAJatavallabhula Narasimha Sastry · Longview, TXBuilt 2006 · S/N 18281796 N79MPMissouri State Highway Patrol · Jefferson City, MOBuilt 2001 · S/N 18281003 N8050JParamus Flying Club Inc · Fairfield, NJBuilt 2005 · S/N 18281633 N806THFvx Research · Bristow, VAFirst renewal noticeBuilt 2010 · S/N 18282266 N807VROrton Thomas L · Clifford, MIBuilt 2007 · S/N 18281926 N808BPChemtech-Engineering Inc · Racine, WIBuilt 2004 · S/N 18281455 N808DWHall Danny J · Torrington, CTBuilt 2001 · S/N 18281044 N809CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281222 N80PELakepoint Aviation LLC · Augusta, KSBuilt 2004 · S/N 18281472 N810CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281247 N810RFQuiring Mark Edmond · Mount Pleasant, TXBuilt 2012 · S/N 18282329 N811AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281196 N811AHOtv Leasing · Manassas, VABuilt 2010 · S/N 18282240 N811CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281248 N811GWGreat Western Aviation Leasing LLC · Ogden, UTBuilt 2002 · S/N 18281101 N811TWNova Aircraft Holdings Inc · San Diego, CABuilt 2002 · S/N 18281118 N812AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281197 N812MCFly Bye Air LLC · Southport, NCBuilt 2003 · S/N 18281208 N813CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281249 N813HCGeorgia Forestry Commission · Macon, GABuilt 2004 · S/N 18281460 N815CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281250 N815DZBlue Sky LLC · Overland Park, KSBuilt 2001 · S/N 18280985 N816CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281251 N816FATemm 2000 Inc · Arcola, ILBuilt 2002 · S/N 18281116 N816JHIndy Aviation LLC · Carmel, INBuilt 2001 · S/N 18280982 N817CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281257 N818ARLandsworth Corp · Monterey, CABuilt 2004 · S/N 18281430 N818CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281258 N819CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281259 N819PSWoodard William R · University Place, WABuilt 2003 · S/N 18281241 N81LBGaravaglia Gary E · Statesville, NCBuilt 2001 · S/N 18281042 N820BTJjsap Holdings LLC · Kalispell, MTBuilt 2005 · S/N 18281574 N820CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281260 N820KECannery Leasing Ltd · Friday Harbor, WABuilt 2007 · S/N 18281884 N821CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281261 N821WWDouble Whiskey Flyers LLC · Highlands Ranch, COBuilt 2006 · S/N 18281828 N823CSRouch Timothy · Sturgis, MIBuilt 2012 · S/N 18282323 N824AJWilliams John R Trustee · Trophy Club, TXBuilt 2012 · S/N 18282315 N824HAFeingersh Harry · Houston, TXBuilt 2006 · S/N 18281824 N824NMMastrangelo Barry D · Cape May Ch, NJBuilt 2001 · S/N 18280972 N826CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281264 N826TRRcc Resource Commerical Inc · Dallas, TXBuilt 2010 · S/N 18282241 N827CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281271 N828CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281272

Back to Cessna 182T