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.

N366NHState Of New Hampshire Dept Of Safety · Concord, NHBuilt 2008 · S/N 18282106 N370CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18282000 N370JHNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282191 N371CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18282001 N372AFFlyslow Aviation LLC · Sterling, VABuilt 2003 · S/N 18281191 N372CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18282002 N373CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281986 N374CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281987 N37HDJohnston-Matejek Aviation LLC · Houston, TXBuilt 2006 · S/N 18281850 N382AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281192 N383KDT-6 LLC · Wilmington, DEBuilt 2012 · S/N 18282358 N385RBNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282199 N387CSDa Aviation LLC · Englewood, COBuilt 2011 · S/N 18282287 N38ALAirloc LLC · Atlanta, GABuilt 2004 · S/N 18281450 N38BGCary Aviation LLC · Myrtle Beach, SCS/N 18281334 N38USUnited States Aviation Underwriters Inc · New York, NYBuilt 2002 · S/N 18281173 N397CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282118 N397CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282189 N398CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281998 N399CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281999 N3YUT2 Aviation LLC · Missouri City, TXBuilt 2004 · S/N 18281453 N401SWAnderson James Kenneth Jr · Tulsa, OKBuilt 2011 · S/N 18282301 N404KRCenterline Aviation Inc · Middletown, DEBuilt 2009 · S/N 18282203 N410KCTerrapin Station Air LLC · Spokane, WABuilt 2007 · S/N 18282012 N411CPX-Ray Lima Aviation LLC · Fort Lauderdale, FLBuilt 2010 · S/N 18282232 N411LPPlan A Ltd · Middletown, DEBuilt 2002 · S/N 18281114 N413RDDos Amigos Air Service LLC · Carrizo Springs, TXBuilt 2004 · S/N 18281464 N417DDSc Flyers Inc · Wilmington, DEBuilt 2002 · S/N 18281169 N419JARaw Aviation LLC · Wichita, KSBuilt 2007 · S/N 18281885 N41DLLdair Inc · Roanoke, VABuilt 2002 · S/N 18281142 N420CSSugar Lips Aviation LLC · Kalispell, MTBuilt 2005 · S/N 18281650 N420FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 2004 · S/N 18281494 N420HPBraden Health LLC · Greensboro, NCBuilt 2005 · S/N 18281637 N421FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 2004 · S/N 18281495 N421SARedbreast Aviation LLC · Boonton, NJBuilt 2004 · S/N 18281378 N422MTMissouri Dept Of Transportation · Jefferson City, MOBuilt 2008 · S/N 18282051 N424STMisto Louis III · Westerly, RIBuilt 2005 · S/N 18281739 N424TRCovin Equipment LLC · Arlington, TXBuilt 2005 · S/N 18281562 N425KPBrown David B · Cumberland, VAS/N 18281383 N425PKGood Flight LLC · San Luis Obispo, CABuilt 2004 · S/N 18281449 N427JDMule Air LLC · San Antonio, TXBuilt 2005 · S/N 18281593 N428LBMam Aviation LLC · New York, NYBuilt 2006 · S/N 18281813 N428MTNby Productions · Manassas, VABuilt 2010 · S/N 18282234 N429JPHnb Aviation LLC · Forestburg, TXBuilt 2007 · S/N 18281955 N431AFBuha Holdings LLC · Paris, TXBuilt 2003 · S/N 18281193 N434CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282192 N435TAPanther Med LLC · Derby, KSBuilt 2001 · S/N 18281035 N439CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282355 N444VBYoung Reginald S · Buffalo Junction, VABuilt 2001 · S/N 18281034 N445CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282356

Back to Cessna 182T