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.

N777NTN777nt LLC · Fort Mill, SCBuilt 1975 · S/N 21060972 N777RKing Winn K · Gladewater, TXBuilt 1972 · S/N 21059551 N7874J2f Trade LLC · Collinsville, TXS/N 21060597 N811ECChin-Loy Christopher Wayne Trustee · Tamarac, FLBuilt 1975 · S/N 21060702 N8127L2f Trade LLC · Gainesville, TXS/N 21060614 N8128LSayco Aviation LLC · Fayetteville, GABuilt 1974 · S/N 21060615 N8137LShreve Jerry · Warrensburg, MOBuilt 1974 · S/N 21060624 N827TWGardner Thomas W · Lincoln, MEBuilt 1973 · S/N 21059836 N84777Flight Path Partners LLC · San Mateo, CABuilt 1972 · S/N 21059624 N86AGGarlow Terry J · Granbury, TXBuilt 1975 · S/N 21060966 N8935MGoldberg Alan N · Point Clear, ALBuilt 1972 · S/N 21059635 N90MBBleeker Buchanan B · Flagstaff, AZBuilt 1973 · S/N 21060153 N93035Des Aircraft LLC · Marianna, ARBuilt 1974 · S/N 21060232 N93052Pfm 2025 LLC · Lake Forest, ILBuilt 1974 · S/N 21060244 N93112Strack Air LLC · Yorba Linda, CABuilt 1974 · S/N 21060267 N93135Shannon Frances W · Clarksdale, MSBuilt 1974 · S/N 21060278 N93157Haley Mitchell P · Big Lake, MNBuilt 1974 · S/N 21060285 N93260Webb Michael · Magnolia, TXBuilt 1974 · S/N 21060322 N93887Dan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1974 · S/N 21060445 N93974Just Plane Stupid LLC · Loveland, COBuilt 1974 · S/N 21060469 N939RLHintzsche Roger E Trustee · Dekalb, ILBuilt 1974 · S/N 21060470 N93JESibora Group LLC · Gilbert, AZBuilt 1974 · S/N 21060540 N94018Northern Air Transport Inc · Mora, MNBuilt 1974 · S/N 21060483 N94077Milky Way LLC · Fresno, CABuilt 1974 · S/N 21060497 N94206Andrews Gordon Bruce · Ellicott City, MDBuilt 1974 · S/N 21060539 N94211Jskp Enterprises LLC · Dover, DEBuilt 1974 · S/N 21060542 N94267Hop Props LLC · Houston, TXBuilt 1974 · S/N 21060571 N94285Great Lakes Enterprises · Heron, MTBuilt 1974 · S/N 21060584 N953STBoone Keith · Cabot, ARBuilt 1976 · S/N 21061155 N970MRGlobal Aviation LLC · Grain Valley, MOS/N 21059904 N987MZanze David · Cedar City, UTBuilt 1975 · S/N 21061093 N99DSToutant Roland J · Woodstock, CTBuilt 1972 · S/N 210-59608 N99GBBright Edgar H · Collegeville, PABuilt 1973 · S/N 21060115 N9JPEcho Air Inc · Woodstock, GABuilt 1973 · S/N 210-59926

Back to Cessna 210L