Skip to content

Registered aircraft · 40

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

N212PMEllisor Don · Grapeland, TXBuilt 1966 · S/N 337-0527 N22MDHolland Bryan K · Sterling, AKBuilt 1966 · S/N 337-0590 N22PNLingle Gordon D · Gun Barrel City, TXBuilt 1966 · S/N 337-0538 N2332SLouisiana Military Museum · Abbeville, LAS/N 337-0632 N2344SAnderas Per R · Green Bay, WIBuilt 1967 · S/N 337-0644 N2345SSummers Jeffrey L · Pekin, INBuilt 1967 · S/N 337-0645 N2362SMclaren Institute Of Transporation Technologies · Goode, VABuilt 1967 · S/N 337-0662 N2366SDaughtrey Kevin E · Arcadia, FLS/N 337-0666 N2382SMielczarek Joe I · Santa Paula, CABuilt 1967 · S/N 337-0682 N2397SState Of Wisconsin · Madison, WIBuilt 1967 · S/N 337-0697 N2413SQualitair LLC Trustee · MichelstadtBuilt 1967 · S/N 337-0713 N2417SPiasecki Aircraft Corporation · Coatesville, PABuilt 1967 · S/N 337-0717 N337JLDavis Mike D · Huntersville, NCS/N 337-0708 N337MMAugugliaro Robert J · Albuquerque, NMBuilt 1967 · S/N 337-0608 N337WTSunset Aviation LLC · Wilmington, DEBuilt 1967 · S/N 337-0661 N337XXPfister David E · Harlan, INS/N 337-0726 N358Bipes Anthony · Forest Lake, MNBuilt 1967 · S/N 337-0737 N3JNGas Aviation LLC · Decatur, TNBuilt 1966 · S/N 337-0558 N44LBCadet Michel · Locust Grove, GABuilt 1966 · S/N 337-0561 N4GSmith Jeary K · Greenfield, INBuilt 1967 · S/N 337-0686 N52515Oscar Deuce LLC · Virginia Beach, VABuilt 1967 · S/N 337M0048 N5426SPetrof Karl J · Ligonier, PAS/N 337-0526 N5428SLepping Kurt · Wasilla, AKS/N 337-0528 N5431SGreensburg Jeanette Airport Administration Inc · Jeannette, PABuilt 1966 · S/N 337-0531 N5434SAnderas Per R · Green Bay, WIS/N 3370534 N5446SDelgado Alvaro A · Orange, VABuilt 1966 · S/N 337-0546 N5451SDodson William G · Quebeck, TNBuilt 1966 · S/N 337-0551 N5456SWood Charles G Trustee · Amarillo, TXBuilt 1967 · S/N 337-0556 N5460SMatanane Roke C · Barrigada, GUBuilt 1966 · S/N 337-0560 N5463SPlanzer Henry L · Dalton, GABuilt 1966 · S/N 337-0563 N5475SGillies Paul A · Grapevine, TXBuilt 1966 · S/N 337-0575 N5477SChickasha Wings Inc · Chickasha, OKBuilt 1966 · S/N 337-0577 N5478SPoppima Photonix · Granbury, TXBuilt 1966 · S/N 337-0578 N5487SRobbins Phillip W · Maryville, TNBuilt 1966 · S/N 337-0587 N556CLLutz Ed · Pine Valley, CABuilt 1966 · S/N 337-0543 N630AMBhh Leasing #3 LLC · Pensacola, FLBuilt 1968 · S/N 337-M0347 N65MMShewbart Keith M · Crystal River, FLBuilt 1969 · S/N 337M0446 N814JAdvantage Aviation Services LLC · South Saint Paul, MNS/N 337-0596 N887JBBertrand Carolyn L · Ridgecrest, CABuilt 1966 · S/N 337-0559 N888BAmerican Airpower Museum · Farmingdale, NYBuilt 1967 · S/N 3370586

Back to Cessna 337B