Skip to content

Registered aircraft · 234

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

N101JHHi-Per Aviation Inc · Arroyo Grande, CABuilt 1972 · S/N 21059759 N10242Alexander Holding Services Inc · Newark, DEBuilt 1972 · S/N 21059704 N10HGGerardy Harlan D · Gruver, TXBuilt 1974 · S/N 21060169 N10HLHoyt Robert H Trustee · Canby, ORBuilt 1975 · S/N 21060646 N10YSeitz William D · Gordonville, TXBuilt 1972 · S/N 21059697 N110YDLloyd Clee · Canby, ORBuilt 1975 · S/N 21060858 N1110SMob Aviation USA LLC · Kissimmee, FLS/N 21061119 N115CWWhitlock Gary D · Melbourne, FLBuilt 1974 · S/N 21060520 N1190QBritell Andrew Paul · Sandwich, NHBuilt 1972 · S/N 21059690 N121CEAdvanced Flight Instruction LLC · Greenwood, DEBuilt 1974 · S/N 21060503 N123CEBas Part Sales LLC · Greeley, COS/N 21061054 N12KFN12kf LLC · Pass Christian, MSBuilt 1973 · S/N 21059853 N12PWOhio State University College Of Engineering · Columbus, OHBuilt 1972 · S/N 21059796 N1574PSouthern Seaplane Inc · Belle Chasse, LABuilt 1976 · S/N 21061258 N1609XHarvey P J · Midland, TXBuilt 1975 · S/N 21060645 N1651XPeters Mark E · Newport News, VABuilt 1975 · S/N 21060686 N1656XAnderson George E · Newnan, GABuilt 1975 · S/N 21060691 N1696XCenturion LLC · New Bern, NCBuilt 1975 · S/N 21060731 N1698XCmo Blue Sky LLC · Tomball, TXS/N 21060733 N1716XBell Brian · Oakland, CABuilt 1975 · S/N 21060738 N1720XKregel Brian D · Garnavillo, IABuilt 1975 · S/N 21060742 N1734XRight Wing Left Wing Flyers LLC · Cleveland, GABuilt 1975 · S/N 21060755 N1744XDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 21060765 N1754XWest Alabama Lime Co Inc · Livingston, ALBuilt 1975 · S/N 21060775 N1763XRobins Nest Aviation LLC · Harrison, OHBuilt 1975 · S/N 21060784 N1764XLeschber Larry · Hutto, TXBuilt 1975 · S/N 21060785 N176LLClear Above LLC · Haymarket, VABuilt 1975 · S/N 21061135 N1770XPark Avenue Group Inc · Stuart, FLBuilt 1975 · S/N 21060791 N1794XGulf Atlantic Airways Inc · Gainesville, FLBuilt 1975 · S/N 21060814 N1797XN1797x Aero LLC · Gulf Breeze, FLBuilt 1975 · S/N 21060817 N1798XN1798x LLC · Etna Green, INBuilt 1975 · S/N 21060818 N200LDFenske Jeffrey D · Gold Hill, ORBuilt 1973 · S/N 21059895 N2029SCanyon West LLC · Amarillo, TXBuilt 1975 · S/N 21060997 N2036SLissie Flying Service · Lissie, TXBuilt 1975 · S/N 21061004 N2103SSan Diego Flight Corp · San Diego, CABuilt 1975 · S/N 21061067 N2105SSouthport Aviation LLC · Cape Coral, FLBuilt 1976 · S/N 21061069 N210BJSummers Equipment Leasing Inc · Wilmington, DEBuilt 1974 · S/N 21060221 N210BNBy Land Air And Sea LLC · Alto, MIBuilt 1974 · S/N 21060526 N210BVPlane Fun Inc Tr Trustee · Snellville, GABuilt 1975 · S/N 21061114 N210BWSc & Dss LLC · Mckinney, TXBuilt 1976 · S/N 21061483 N210BXNova Aircraft Holdings Inc · San Diego, CABuilt 1972 · S/N 21059583 N210CHOne Up LLC · Stuttgart, ARBuilt 1974 · S/N 21060142 N210DCRrr Land & Cattle Co LLC · Midland, TXBuilt 1973 · S/N 21060159 N210DDDwoskin David F Trustee · San Pedro, CABuilt 1976 · S/N 21061464 N210DGWashburn Stig K · Westminster, MABuilt 1972 · S/N 21059559 N210DNMartin John J · Honesdale, PAS/N 21059676 N210FBBongard Frederic S · Torrance, CABuilt 1974 · S/N 21060441 N210GATwin D LLC · Lake City, FLBuilt 1974 · S/N 21060480 N210GMStipe Leslie Wayne · Mcalester, OKBuilt 1976 · S/N 21061393 N210GSRetail Online Solutions Inc · Columbus, OHBuilt 1976 · S/N 21061283

Back to Cessna 210L