Skip to content

Registered aircraft · 58

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

N101AWHurley Michael P · Wasilla, AKBuilt 1999 · S/N 1445 N105BBWitt Benjamin D · Great Falls, MTBuilt 1998 · S/N 1416 N109AMRussell Construction · Douglas, WYBuilt 2000 · S/N 1464 N111XJCc Bar Ranch LLC · Texarkana, TXBuilt 1998 · S/N 1429 N113NShaw Brandon L · Juneau, AKBuilt 1998 · S/N 1422 N119WPSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 1425 N124HULeaders Kurt W · Clear Lake, MNBuilt 1998 · S/N 1413 N125HUWyatt Gregory P · Billings, MTBuilt 1998 · S/N 1423 N12HYRegistration Pending · Nephi, UTRegistration pendingBuilt 1999 · S/N 1448 N12TESchwigen Justin R · Alton, ILBuilt 1998 · S/N 1440 N141FAnderson Jon J · Hill City, SDBuilt 1998 · S/N 1400 N153CHarless Richard K · Battle Mountain, NVBuilt 1998 · S/N 1415 N15LFNorthrup George William · Ellicottville, NYBuilt 1998 · S/N 1395 N168FSWhitley Pat · Altoona, ALBuilt 1998 · S/N 1404 N17HYMorong William G · Lincolnville, MEBuilt 1999 · S/N 1454 N19HYGrqg Flyer LLC · Annandale, NJBuilt 1999 · S/N 1459 N19LGTail Chaser LLC · Wilmington, DEBuilt 1998 · S/N 1441 N202BEKruse Stephan L Jr · Norridgewock, MES/N 1462 N214CMeister Curtis E · Plover, WIBuilt 1998 · S/N 1430 N221JWSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1998 · S/N 1419 N232CDavid Stix Jr · Fernley, NVBuilt 1998 · S/N 1442 N234SPSchmidt W William DBA · Lexington, OHBuilt 1998 · S/N 1435 N241VYShallbetter Joseph R · Marana, AZBuilt 1999 · S/N 1449 N24HUFernweh Aviation LLC · Bandon, ORBuilt 1998 · S/N 1403 N26HVHotel Victor LLC · Bend, ORS/N 1410 N270CRemmick Darwin · Jamestown, NDBuilt 2000 · S/N 1466 N27BEAir N Nautical LLC · Kalispell, MTBuilt 1998 · S/N 1418 N27HRRemer Herbert I · Punta Gorda, FLBuilt 1999 · S/N 1444 N27HYMiand Inc · Laporte, INBuilt 1999 · S/N 1457 N27PJHines Thomas J · Amsterdam, NYBuilt 1998 · S/N 1401 N281CAppel Daniel E · Redfield, SDBuilt 1999 · S/N 1456 N287CHall William Dustin · Elizabeth City, NCBuilt 1999 · S/N 1460 N28AWSkyhook Inc · Nescopeck, PABuilt 1998 · S/N 1439 N28HUKahonees Air Service LLC · Bozeman, MTBuilt 1998 · S/N 1414 N302JBS C Flying Service Inc · Ravenden Springs, ARBuilt 1998 · S/N 1417 N30HUDukes William R · Tallulah, LABuilt 1998 · S/N 1406 N31WFTaylor Peter L · Beaumont, TXBuilt 1999 · S/N 1461 N32HUMdc Aviation Corp Inc · Amsterdam, NYS/N 1402 N401PKJones Roderick H DBA · Thomasville, GABuilt 1998 · S/N 1438 N403Pescatore Thomas F · Monte Vista, COBuilt 1999 · S/N 1451 N40AWKlingbeil Mark T · Bottineau, NDBuilt 1999 · S/N 1452 N415JBBrewer Allen E · Madison, MSBuilt 1999 · S/N 1463 N42AKGerhardt David · Denver, COBuilt 1998 · S/N 1434 N444HUDorsey Sage · Bend, ORBuilt 1998 · S/N 1396 N451GRMidwest Kilo Delta LLC · Clara City, MNS/N 1408 N456AMKrause Kade G · Jackson, MTBuilt 1998 · S/N 1412 N456HUCornelius Wayne · Mount Arlington, NJBuilt 1998 · S/N 1436 N503MZWight Schuyler III · Goldsmith, TXBuilt 1998 · S/N 1405 N526VTN526ma LLC · South Burlington, VTBuilt 1998 · S/N 1411 N56TABarber Jason L · Oil Trough, ARBuilt 1998 · S/N 1420

Back to Aviat A-1A