Skip to content

Registered aircraft · 46

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 ('3990101')
  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 ('3990101')
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.

N127KJSky Flowers Holding Group LLC · Sunrise, FLS/N 10248 N242BWLasensky David W · Newtown Square, PAS/N 10214 N2848Picerno John · Middle Island, NYBuilt 2002 · S/N 10207 N322KLBuyair LLC · Valdosta, GAS/N 10220 N39GDNovember Sierra Romeo LLC · Byron Center, MIS/N 10250 N41NCTiger 41nc LLC · Malvern, PABuilt 2004 · S/N 10234 N50BXAthena Aviation LLC · Greenville, SCBuilt 2003 · S/N 10227 N5XWLewis Everett D · Comfort, TXBuilt 2004 · S/N 10242 N6500ERegistered aircraftBuilt 2005 · S/N 10246 N6506AFallon Timothy R · Ithaca, NYBuilt 2005 · S/N 10247 N6513ZDalcair Inc · Fort Washington, PAS/N 10249 N6554BCitizen Aero Inc Trustee · Sheridan, WYBuilt 2006 · S/N 10251 N79AQSchmidt Steven Tod · Berthoud, COS/N 10206 N8755CDebra Cay LLC · Scottsdale, AZBuilt 2003 · S/N 10223 N923TEDiscover Resources LLC · Norman, OKBuilt 2001 · S/N 10202 N924TEPlyler Robert S · Spring, TXBuilt 2002 · S/N 10203 N925TEHarris David A · Cleves, OHBuilt 2001 · S/N 10204 N926TEAnderson & Associates Inc · Little Rock, ARBuilt 2002 · S/N 10205 N929TEGilling Bert N · Kula, HIBuilt 2002 · S/N 10208 N930TEPeters James L · Lindon, UTBuilt 2002 · S/N 10209 N932TEGilling Bert N · Kula, HIS/N 10211 N933TEBcaz Holdings LLC · Wilmington, DEBuilt 2002 · S/N 10212 N934TESpiwak Andrew · Canyon Lake, TXBuilt 2002 · S/N 10213 N936TELevine Gary H · Davie, FLBuilt 2003 · S/N 10215 N937TEPicton Aaron · Redding, CABuilt 2003 · S/N 10216 N938TETiger Flyers LLC · Centre Hall, PABuilt 2003 · S/N 10217 N939TESherry James Todd · Quinlan, TXBuilt 2003 · S/N 10218 N940TESimmerman John Jr · Harrisburg, NCBuilt 2003 · S/N 10219 N942TECardinal Enterprise LLC · Jackson, WYBuilt 2003 · S/N 10221 N943TEZbikowski Scott · Lino Lakes, MNBuilt 2003 · S/N 10222 N945TELebanon Flying Club Inc · Lebanon, TNBuilt 2003 · S/N 10224 N946TEStrange Bird LLC · Hackensack, NJBuilt 2003 · S/N 10225 N947TESkyway V LLC · Naples, FLBuilt 2003 · S/N 10226 N949TEBarron Wesley Thomas · Port Orange, FLBuilt 2003 · S/N 10228 N950TECrutchfield Randolph E · Scottsdale, AZBuilt 2003 · S/N 10229 N953TEL A Mesa Ventures LLC · Denison, TXBuilt 2004 · S/N 10232 N954TEBabin Michael K Jr · Cresson, TXBuilt 2004 · S/N 10233 N956TERaw Logistics LLC · Bethel, NCBuilt 2004 · S/N 10235 N957TEConlon Kevin P · Lake Geneva, WIBuilt 2004 · S/N 10236 N958TENewman Robert · Groton, NYBuilt 2004 · S/N 10237 N959TELawless John M Jr · Tucson, AZBuilt 2004 · S/N 10238 N960TEBeauregard Timothy · Haslet, TXBuilt 2004 · S/N 10239 N961TETiger Fliers LLC · Island Park, NYBuilt 2004 · S/N 10240 N962TEPayne Mark Howard · Spring, TXBuilt 2004 · S/N 10241 N964TEBedard Robert L · Bolivar, OHBuilt 2005 · S/N 10243 N966TELewis Everett Donald Jr · Comfort, TXBuilt 2005 · S/N 10245

Back to Tiger AG-5B