Skip to content

Registered aircraft · 321

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.

N10FLRandall P Roumillat · Dallas, TXS/N 21062892 N10HMAggst LLC · Shingle Springs, CABuilt 1978 · S/N 21062908 N1128CGibbs Wyatt R · Lodi, CABuilt 1978 · S/N 21062711 N115RPN115rp LLC · Midland, TXBuilt 1977 · S/N 21061944 N117HLZosel Paul J · Bellingham, WABuilt 1976 · S/N 21061649 N11TCShiver James B Jr · Stanley, NMBuilt 1977 · S/N 21062230 N1215MBieber Dale E · Coralville, IABuilt 1977 · S/N 21061924 N121JRKlotz Geoffrey B · Moor Park, CABuilt 1977 · S/N 21061726 N1237MJ&C Walker Aviation LLC · Henderson, TXBuilt 1977 · S/N 21061927 N123DMJacquin Philip Fink · New York, NYS/N 21062663 N125BMBaron Transporation Services LLC · Destrehan, LABuilt 1978 · S/N 21062926 N12PFRucker Gary R · Kingman, AZBuilt 1977 · S/N 21062401 N13TNMcdaniel Robert M · Tonasket, WABuilt 1977 · S/N 21062428 N1576MSkyline Aviation Services LLC · Miramar, FLBuilt 1977 · S/N 21061948 N15DACamborne USA LLC · Collierville, TNS/N 21061765 N15MLN15ml LLC · Cresskill, NJBuilt 1977 · S/N 21061780 N1605MSelter Eric Jay Trustee · Agoura Hills, CABuilt 1977 · S/N 21061950 N193TTBgiii Air LLC · Tampa, FLBuilt 1976 · S/N 21061601 N198ERCloud Dancer LLC · Santa Maria, CABuilt 1977 · S/N 21062298 N19FBWojnicki Chester · Mt Prospect, ILBuilt 1976 · S/N 21061668 N200WRVaughan Jason B · Sublette, KSBuilt 1978 · S/N 21062478 N20HLCs&P Rocky Mountain Inc · Cypress, TXS/N 21061877 N210DMHans Nelson And Son Nursery Inc · Boring, ORS/N T210-62902 N210EBBuell Jack A · St Maries, IDBuilt 1978 · S/N 21062568 N210HPFancy Flyers LLC · Fort Worth, TXBuilt 1977 · S/N 21061829 N210JCPinto Carlos · Tucson, AZBuilt 1978 · S/N 21062619 N210JDCovarrubias Javier Diaz · Rancho Viejo, TXBuilt 1977 · S/N 21062169 N210JHSchultz Wayne T · Madras, ORBuilt 1977 · S/N 21061832 N210JKTebow William M · Bunkie, LABuilt 1977 · S/N 21061901 N210KTMcnulty Ian L · Lisle, ILBuilt 1978 · S/N 21062886 N210PCDiaz Ricardo · North Miami, FLBuilt 1978 · S/N 21062801 N210PLMts Inc · Middletown, DEBuilt 1978 · S/N 21062528 N210TRichard Brady K · Farmers Branch, TXBuilt 1978 · S/N 21062936 N210TRMora Ricardo A · El Paso, TXBuilt 1977 · S/N 21061745 N210VCruiser LLC · Munger, MIS/N 21062675 N213GCEastern Stearman Inc Trustee · Leesburg, VABuilt 1978 · S/N 21062368 N234WIwaa Inc · Woodstock, GABuilt 1976 · S/N 21061618 N235WHTail Aero Corp · Wilmington, DEBuilt 1977 · S/N 21061797 N23HBHotel Bravo Aviation LLC · Houston, TXBuilt 1977 · S/N 21062050 N246ECKnight Air LLC · Wausau, WIS/N 21062435 N248HSLitchfield Lantz · Las Vegas, NVBuilt 1978 · S/N 21062726 N24HSSandoval Ernest D · Cave Creek, AZBuilt 1978 · S/N 21062755 N2525XTolbert Mark A · Canandaigua, NYBuilt 1977 · S/N 21061803 N26PMHill Capital Leasing LLC · Scottsdale, AZBuilt 1977 · S/N 21061791 N270MRFurtado William J III DBA · Fremont, CABuilt 1976 · S/N 21061660 N2743JColman Scott · Tampa, FLBuilt 1976 · S/N 21061690 N2874EMoutafian Adom · Los Gatos, CAS/N 21062773 N297DRMingus Mason · Scottsville, KYBuilt 1978 · S/N 62398 N2SLLowe Aviation LLC · Bountiful, UTBuilt 1977 · S/N 21061908 N301EBQuesnel William G · Truckee, CABuilt 1978 · S/N 21062524

Back to Cessna T210M