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.

N195FAPinkston Pat · Carrollton, ILBuilt 2002 · S/N 18281095 N196PWC I Mckown & Son Inc · Newton, WVBuilt 2004 · S/N 18281368 N1992DRiggan Russell C · Kirkwood, MOBuilt 2005 · S/N 18281716 N1995BN2jz LLC · Amarillo, TXBuilt 2005 · S/N 18281697 N199CACapital Holdings 109 LLC · Potomac, MDBuilt 2005 · S/N 18281548 N199SHPrecision Design Inc · Wilmington, DEBuilt 2008 · S/N 18282078 N19HPState Of Ohio Dept Of Public Safety · Columbus, OHBuilt 2003 · S/N 18281266 N19KHVan Bortel Aircraft Inc · Arlington, TXS/N 18282073 N2006PKnox Timothy A · Tulsa, OKBuilt 2005 · S/N 18281684 N20126Papa Whiskey Enterprises LLC · Merrimack, NHBuilt 2001 · S/N 18280951 N2012YLake Robert P · Fruita, COBuilt 2006 · S/N 18281770 N2014SGaige Gerald · Gassville, ARBuilt 2006 · S/N 18281772 N2020CN2020c LLC · Abilene, TXBuilt 2005 · S/N 18281700 N2027PHake Equipment Leasing LLC · Farmington Hills, MIBuilt 2005 · S/N 18281724 N2028BWeber Richard · Mountain View, CAFirst renewal noticeS/N 18280952 N2040HAbc Plane LLC · Freeport, TXS/N 18281639 N20416Carl L Mccallister Inc · Wilmington, DEBuilt 2005 · S/N 18281642 N2044YPsalm 19:1 Aviation LLC · Annapolis, MDBuilt 2005 · S/N 18281643 N20505Hickin Barkley E · Kissimmee, FLBuilt 2001 · S/N 18280953 N2063PRegistered aircraftBuilt 2005 · S/N 18281644 N207PBBernstein Petra M · Salisbury, MDBuilt 2006 · S/N 18281771 N20945Georgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281295 N2097SLong Island Aviators LLC · Seaford, NYBuilt 2004 · S/N 18281308 N2099NMicheal Charles E · Arlington, TXBuilt 2004 · S/N 18281333 N2103UCramm Raymond Eduard · Palmdale, CABuilt 2005 · S/N 18281660 N2115KLiprie Randal C · Lake Charles, LABuilt 2004 · S/N 18281322 N21198Jackie Hood Farms LLC · Moulton, ALBuilt 2005 · S/N 18281647 N21200Paramus Flying Club Inc · Fairfield, NJBuilt 2005 · S/N 18281732 N2121XTaylor Commercial Properties LLC · Jackson, TNBuilt 2004 · S/N 18281480 N2123EDream Flights LLC · Brewton, ALBuilt 2004 · S/N 18281331 N2123YPalin Investments 3 LLC · Vancouver, WABuilt 2007 · S/N 18281893 N2125ACable Thomas G · Rockford, MIBuilt 2003 · S/N 18281230 N2131ATru Flight Materials LLC · Wilmington, DEBuilt 2005 · S/N 18281649 N2131UAgh Property Investments Inc · Key West, FLBuilt 2003 · S/N 18281227 N21326Ttf Flying LLC · Anderson, SCBuilt 2007 · S/N 18281897 N21331J-Air Eagle LLC · San Antonio, TXBuilt 2007 · S/N 18281898 N2133LGietzen Jeff · Seattle, WABuilt 2003 · S/N 18281287 N2135DN2135d LLC · Eustis, FLBuilt 2007 · S/N 18281899 N21369Smk Holdings LLC · Sandy, UTBuilt 2003 · S/N 18281292 N213GGShortcut LLC · Kihei, HIBuilt 2002 · S/N 18281130 N213LPT31 Aviation LLC · Dallas, TXBuilt 2004 · S/N 18281312 N21413Botwinick Jeffrey Richard Patrick · Syracuse, NYBuilt 2003 · S/N 18281273 N2141DFoturis Inc · Kingston, PABuilt 2003 · S/N 18281297 N2144VAnson Air LLC · Sugar Land, TXBuilt 2003 · S/N 18281276 N21454Textron Aviation Inc · Wichita, KSBuilt 2003 · S/N 18281228 N2146AZhukov Igor · Live Oak, FLBuilt 2003 · S/N 18281265 N214CFKlug Air LLC · Wilmington, DES/N 18281056 N214FAGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281214 N214LE3 Weens LLC · Hoschton, GABuilt 2004 · S/N 18281416 N2151XWcps Aviation LLC · Marietta, GABuilt 2003 · S/N 18281233

Back to Cessna 182T