Skip to content

Registered aircraft · 320

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 ('2073451', '2073452')
  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 ('2073451', '2073452')
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.

N761LGTrinkle Aviation LLC · Kingsburg, CAS/N 21062336 N761LMDyer J Scott · Pleasantville, NYBuilt 1977 · S/N 21062341 N761LUStowell Robert W · La Porte, INBuilt 1977 · S/N 21062348 N761MBGump Timothy K · Dalton Gardens, IDBuilt 1977 · S/N 21062354 N761MERoseburg Skyways LLC · Livermore, CAS/N 21062357 N761MJFritz Mark Andrew · Williamson, GABuilt 1977 · S/N 21062361 N761MSHarvey Scott · Hereford, AZBuilt 1977 · S/N 21062369 N761PPSoheily Holdings LLC · Austin, TXBuilt 1977 · S/N 21062412 N761PRBluff City Bell LLC · Caldwell, IDBuilt 1977 · S/N 21062414 N761QAErnst Gary W · Emerald Hills, CABuilt 1977 · S/N 21062423 N761QXAerial Art Photography · Altadena, CABuilt 1978 · S/N 21062444 N761RCClannalu Air LLC · Midland, TXBuilt 1978 · S/N 21062449 N761RDRobinson John · Farmington, NMBuilt 1978 · S/N 21062450 N761RESecrest Steven J · Roosevelt, UTBuilt 1978 · S/N 21062451 N761RGBas Part Sales LLC · Greeley, COS/N 21062453 N761RLCampbell Gordon S · Concord, CABuilt 1978 · S/N 21062457 N761SBBracl Holdings LLC · Tonganoxie, KSBuilt 1978 · S/N 21062471 N761SGThurmond Clark · Georgetown, TXBuilt 1978 · S/N 21062476 N761SHJs Flying Services LLC · Reno, NVBuilt 1978 · S/N 21062477 N761STBode Aviation Inc · Albuquerque, NMBuilt 1978 · S/N 21062487 N761TCMichigan Scientific Corp · Milford, MIBuilt 1978 · S/N 21062496 N761THBlack Forest Wings LLC · Noblesville, INBuilt 1978 · S/N 21062501 N761TKRichards And Richards · Nucla, COBuilt 1978 · S/N 21062503 N761TLOmni International Services Inc · Reno, NVBuilt 1978 · S/N 21062504 N761TMHwbec761 LLC · Los Ranchos, NMBuilt 1978 · S/N 21062505 N761TYAdw N761ty LLC · Chicago, ILBuilt 1978 · S/N 21062516 N761VTCharlie Kilo Romeo LLC · Georgetown, TXBuilt 1978 · S/N 21062559 N761VWKennedy M John · Gillette, WYBuilt 1978 · S/N 21062562 N761WHPierson Tim E · Gooding, IDBuilt 1978 · S/N 21062573 N761WQTower Aircraft Associates Inc · Ventura, CAS/N 21062580 N761WTCv Aviation LLC · Logan, UTBuilt 1978 · S/N 21062583 N761XEGordon Bruce S Trustee · Aspen, COBuilt 1978 · S/N 21062594 N761XFRapa Dennis H · North Dartmouth, MAS/N 21062595 N761XGMedusa Inc · Lexington, VABuilt 1978 · S/N 21062596 N761XYAshby Scott J · Lemoore, CABuilt 1978 · S/N 21062612 N761XZKrabill Enterprises LLC · Christmas Valley, ORBuilt 1978 · S/N 21062613 N761YDAero Clean Technologies LLC · Lynchburg, VABuilt 1978 · S/N 21062617 N761YGGoody Birds LLC · Prattville, ALBuilt 1978 · S/N 21062620 N761YHArnett Family Inc · Mesa, AZS/N 21062621 N761YKFanning Fred W · Fairlawn, OHBuilt 1978 · S/N 21062623 N761YMSkyberry Jam Aviation LLC · Coppell, TXS/N 21062625 N761YSThompson Gary P · Mammoth Lakes, CABuilt 1978 · S/N 21062630 N761YWWalker Gilbert C · Camerillo, CABuilt 1978 · S/N 21062634 N761ZBIts Academic Inc · Elyria, OHBuilt 1978 · S/N 21062639 N761ZEBrandvik Pipe & Equipment Inc · Borger, TXS/N 21062642 N781CBMiller Charles Litle Trustee · Fresno, CABuilt 1977 · S/N 21062235 N78MKNelleh LLC · Liberal, KSBuilt 1978 · S/N 21062587 N78WVOrange Motion Trading LLC · Las Vegas, NVBuilt 1977 · S/N 21062214 N79CHPala Angel E · Taos, NMBuilt 1978 · S/N 21062615 N7UBWhite James V · Prescott, AZBuilt 1976 · S/N 21061593

Back to Cessna T210M