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.

N716MCWing & A Prayer LLC · Wilmington, DEBuilt 2005 · S/N 18281717 N716MTColvin Mariann · Round Rock, TXBuilt 2001 · S/N 18281037 N717CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N 18282250 N718CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281713 N719CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281714 N71BTriplett Gregory S · Groveland, CABuilt 2003 · S/N 18281289 N721ZASky-Vu Flyers Inc · Fishers, INBuilt 2004 · S/N 18281439 N7260QNaples Flying Club Inc · Naples, FLBuilt 2001 · S/N 18280957 N72612Washington State Dept Of Transp · Tumwater, WAS/N 18280988 N726SAInternational Air Services Inc Trustee · Carson City, NVBuilt 2010 · S/N 18282221 N72780Dean'S Flight Inc · Pembine, WIS/N 18280954 N72798Skylane 72798 LLC · Winston Salem, NCBuilt 2001 · S/N 18280946 N727CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N 18282255 N727NSBarrett Kemberly · Woodway, TXBuilt 2006 · S/N 18281809 N729CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281757 N72KFKirkpatrick John Drew · Post, TXBuilt 2004 · S/N 18281361 N72MCAa-Aero Inc · Fairfield, NJBuilt 2005 · S/N 18281653 N731CLNby Productions · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282256 N735SW5 Sierra Whiskey LLC · Sonora, CABuilt 2003 · S/N 18281240 N738CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281761 N739CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281762 N740CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281764 N741CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281790 N742CPCivil Air Patrol · Naxwell Afb, ALBuilt 2006 · S/N 18281799 N743CPCivil Air Patrol · Naxwell Afb, ALBuilt 2006 · S/N 18281800 N744CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281803 N745AGJ&M California Land Company Inc · Bakersfield, CAS/N 18281558 N745CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281806 N746TCSmith Daniel Harold Jr · Pembroke, MABuilt 2006 · S/N 18281749 N747GKEastern Stearman Inc Trustee · Leesburg, VABuilt 2007 · S/N 18282029 N759CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282119 N759THJones Darrell · Columbia, MOS/N 18281219 N762TRWood Eugene H · Hickory, NCBuilt 2001 · S/N 18281004 N767CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282120 N767LRegistered aircraftBuilt 2002 · S/N 18281122 N767XMNew Landing Aviation LLC · Yonges Island, SCBuilt 2007 · S/N 18282043 N771CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281781 N771TMMid-South Aviation LLC · Caruthersville, MOBuilt 2011 · S/N 18282286 N774CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N 18282257 N775CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281779 N775MRTorres Kim Renee · Castroville, TXS/N 18281073 N776CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281776 N7772WWadhwa Anil Jethanand · Clarksville, TNBuilt 2004 · S/N 18281336 N77812Wildman Gary C Trustee · Germantown, TNBuilt 2005 · S/N 18281549 N7781EGibson Paul Trustee · Groveland, CABuilt 2005 · S/N 18281621 N778CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281778 N7791CRohlfing Frederic L · Kirkwood, MOBuilt 2004 · S/N 18281423 N780CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281780 N782CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281782 N782RMMbs Aviation LLC · York, SCBuilt 2005 · S/N 18281730

Back to Cessna 182T