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.

N5348EDexter Brady R · Chambers, NEBuilt 2003 · S/N 18281212 N53610Joe Wigginton Leasing LLC · Henderson, NVS/N 18281223 N536GRNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282182 N539MYMiller Aviation LLC · Murfreesboro, TNBuilt 2010 · S/N 18282238 N53FVTorres Ramon Luis · San Juan, PRS/N 18281083 N53KPMateos Louise M · Santa Clara, CABuilt 2005 · S/N 18281541 N542ECWang Warner Weihsu · Vienna, WVBuilt 2005 · S/N 18281691 N546KWard Mark E · Brookfield, WIBuilt 2001 · S/N 18281013 N548RGosnell Christopher Carter · Magnolia, ARBuilt 2005 · S/N 18281576 N54KPScheuers Alan · Murfreesboro, TNBuilt 2005 · S/N 18281542 N552MNMtc Air LLC · Blue Ridge, GABuilt 2005 · S/N 18281588 N554WMValdosta Flying Group LLC · Valdosta, GAFirst renewal noticeBuilt 2005 · S/N 18281666 N560ABQuartermaster Growth LLC · Vashon, WABuilt 2007 · S/N 18281947 N561MBVital Equipment LLC · Midland, TXBuilt 2004 · S/N 18281425 N562CBKqm Aviation · Bristow, VABuilt 2010 · S/N 18282207 N567CPCivil Air Patrol · Maxwell Afb, ALS/N 18282167 N570DBAtlas Aviation Tampa Inc · Tampa, FLBuilt 2005 · S/N 18281570 N571MCThompson Gary R · Discovery Bay, CABuilt 2001 · S/N 18281038 N574CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282121 N576CACivil Air Patrol · Montgomery, ALBuilt 2008 · S/N 18282122 N576DSLcb Leasing · Bristow, VABuilt 2010 · S/N 18282229 N577TZWestbank Fishing LLC · Kiln, MSBuilt 2002 · S/N 18281123 N579ER22 H20 LLC · Montgomery, TXBuilt 2005 · S/N 18281599 N580DDDarling John B II · Dedham, MEBuilt 2002 · S/N 18281184 N580TF1294 Transportation Corp · Speonk, NYBuilt 2004 · S/N 18281317 N580WAWipaire Inc · South St Paul, MNBuilt 2002 · S/N 18281178 N582TCBreak For It Aviation LLC · Draper, UTBuilt 2005 · S/N 18281550 N584LQAir Shares LLC · Casper, WYBuilt 2005 · S/N 18281600 N585AMPj Aviation LLC · Richmond Hill, GABuilt 2005 · S/N 18281585 N585CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282168 N58CR7192 Locke Road LLC · Millington, TNBuilt 2005 · S/N 18281544 N590CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282171 N591CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282176 N592JSStraut James M · Upper Saddle River, NJS/N 18281041 N593CPCivil Air Patrol · Montgomery, ALS/N 18282178 N594CPCivil Air Patrol · Maxwell Afb, ALS/N 18282180 N59EFTancredi Andrew D · Germantown, TNBuilt 2004 · S/N 18281359 N600PKGetzel Air LLC · Conover, WIBuilt 2008 · S/N 18282082 N6013KLdm LLC · Cuba, MOBuilt 2006 · S/N 18281795 N6013SStomio LLC · Covina, CABuilt 2006 · S/N 18281797 N6013VFlynn James H Jr · Saratoga Springs, NYBuilt 2006 · S/N 18281798 N6019XRuegg Charles E · Belfast, MEBuilt 2006 · S/N 18281812 N6020F7l Air LLC · Franklin, TXBuilt 2006 · S/N 18281814 N6021MPark Rapids Avionics Inc · Park Rapids, MNBuilt 2006 · S/N 18281817 N6025DMorgan Joel E · Mcalester, OKBuilt 2006 · S/N 18281830 N60279Tensco Inc · Twin Falls, IDBuilt 2006 · S/N 18281804 N6032DBravo Gulf Zulu Aviation LLC · Newark, DEBuilt 2006 · S/N 18281820 N6038VEdb Air Inc · Wilsonville, ORBuilt 2006 · S/N 18281832 N60398Wagoner Aviation LLC · Clovis, CABuilt 2006 · S/N 18281834 N6040CZach Air Corp · Byfield, MAS/N 18281835

Back to Cessna 182T