Skip to content

Registered aircraft · 157

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

N1511EPatton D Pettijohn · Wasilla, AKBuilt 1946 · S/N 7AC-5074 N1830EMeyer Scott David · Plano, TXBuilt 1946 · S/N 7AC-5397 N191DPNotre Amour LLC · Cypress, TXS/N 7EC335 N206GWOconnor Christopher G · New Haven, CTBuilt 1956 · S/N 528 N4306CHarsh David L · Daniels, WVBuilt 1955 · S/N 7EC306 N4308CBrooks Clifton B · Harrah, OKBuilt 1955 · S/N 7EC-308 N4310CTadic Michael · Skagway, AKBuilt 1955 · S/N 7EC-310 N4311CPage Aerial Service Inc · Rochelle, ILBuilt 1955 · S/N 7EC-311 N4313CJohnson Charles M · Malta, MTBuilt 1955 · S/N 7EC-314 N4316CNorman Shawn T · Rothsay, MNBuilt 1955 · S/N 7EC-317 N4317CSasinowski Joseph Vance · Anchorage, AKBuilt 1955 · S/N 7EC-318 N4318CEakins Clifford P · Bloomfield, IABuilt 1955 · S/N 7EC-323 N4321CWeiss Elliott · Fresno, TXS/N 7EC-326 N4322CSparrowhawk Aviation LLC · Moraine, OHS/N 7EC-327 N4324CCornfield Cruisers LLC · Urbandale, IABuilt 1955 · S/N 7EC-333 N4334CEyring Joshua S · Diamond, OHBuilt 1955 · S/N 7EC-347 N4336CFlying Eagle LLC · Billings, MTS/N 7EC-352 N4337CSpence Stephen L · N Richland Hills, TXS/N 7EC-353 N4339CMurray Erwin L Jr DBA · Emporium, PABuilt 1955 · S/N 7EC-355 N4340CAndersen Andy · Sutton, AKBuilt 1955 · S/N 7EC-356 N4343CHarwood Mark D · Cossayuna, NYBuilt 1955 · S/N 7EC-361 N4346CHill H Charles II · South Hero, VTBuilt 1955 · S/N 7EC-365 N4351CKinkle Douglas C Trustee · Colusa, CABuilt 1955 · S/N 7EC-370 N4352CThor David L · Thompson Falls, MTBuilt 1955 · S/N 7EC-371 N4353CKeran Gary R · Natchitoches, LABuilt 1955 · S/N 7EC-372 N4354CDavis Isaac J · Soldotna, AKS/N 7EC-373 N4355CHaynes William S · Chillicothe, TXBuilt 1955 · S/N 7EC-374 N4357CWarren Mark A · Colorado City, COBuilt 1955 · S/N 7EC-376 N4361CBogan Jimmy III · Denison, TXS/N 7EC-384 N4363CHusmann Mark D · Delta, COBuilt 1956 · S/N 7EC-386 N4365CPeters Patrick J · Wasilla, AKBuilt 1956 · S/N 7EC-388 N4369CObrien James J III · Moreno Valley, CABuilt 1956 · S/N 7EC-393 N4370CPhillips Nickolas Hunter · Mikana, WIBuilt 1956 · S/N 7EC-394 N4371CMayhew James · Greenfield, INS/N 7EC-395 N4374CAir-O-Drome Aviation LLC · Caldwell, IDBuilt 1956 · S/N 7EC-398 N4375CStone Philip R · East Syracuse, NYBuilt 1956 · S/N 7EC-399 N4377CThrash Howard G II · Lubbock, TXBuilt 1956 · S/N 7EC-401 N4383CCummings Nancie Jean · Miami, FLBuilt 1956 · S/N 7EC-409 N4387CPearlman Aircraft Company · Orlando, FLBuilt 1956 · S/N 7EC-416 N4390CBloom Jonah M · Palmer, AKS/N 7EC-419 N4393CMitchell Lauren · Pacific Grove, CABuilt 1956 · S/N 422 N4397CChamp Pilots LLC · Forsyth, GABuilt 1956 · S/N 7EC-426 N4398CSnake Bit Aviation LLC · Pelham, GABuilt 1956 · S/N 7EC-427 N4399CDunbar Clayton J · Bakersfield, CABuilt 1956 · S/N 7EC-428 N44278Fredrickson Mark J · Chetek, WIBuilt 1958 · S/N 642 N4566EBaker Jim A · Hermosa, SDS/N 7EC-6 N457FAHartfiel Joel T · Glenwood, IABuilt 1956 · S/N 457 N462TAeronca Flyers Inc · Wilmington, DEBuilt 1956 · S/N 7EC-510 N4656GFoss Jared K · Greenbush, MNBuilt 1957 · S/N 7EC 598 N4697EIverson James P · Soldotna, AKBuilt 1950 · S/N 7EC-44

Back to Champion 7EC