Skip to content

Registered aircraft · 28

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

N206JDZulu Flight LLC · Washougal, WABuilt 1968 · S/N P206-0536 N206JVVercoe Jeffrey · Lincoln, MTBuilt 1968 · S/N P206-0556 N268DLCrenshaw Robert L · Goldsboro, NCBuilt 1969 · S/N P206-0570 N316MLJump N316ml LLC · East Berlin, PABuilt 1969 · S/N P2060549 N360MWMission Wings International Inc · Salem, OHS/N P206-0572 N426ASSaylor Alvin N Jr · Friendswood, TXBuilt 1970 · S/N P206-0590 N55RHMccarthy Michael E · Martinez, CABuilt 1969 · S/N P206-0584 N8725ZRomine George · Tucson, AZBuilt 1968 · S/N P206-0525 N8727ZRobertson Reuben · Johnson City, TNBuilt 1968 · S/N P206-0527 N8732ZZiprik Russell L · Ball Ground, GABuilt 1968 · S/N P206-0532 N8733ZTerway William · Wilsonville, ORBuilt 1968 · S/N P206-0533 N8734ZHardin Matthew W · Rutherford, CABuilt 1968 · S/N P206-0534 N8735ZMcgarity Justin D · Paragould, ARBuilt 1968 · S/N P206-0535 N8753ZBloated Armadillo Adventures Corp · Wilmington, DES/N P206-0553 N8754ZBwana Z Transporation LLC · Missoula, MTBuilt 1968 · S/N P206-0554 N8758ZBellows Paul F · Vancouver, WABuilt 1968 · S/N P206-0558 N8759ZHelin Bruce A Trustee · Flagstaff, AZBuilt 1968 · S/N P206-0559 N8761ZHaag Walter G · Fall City, WABuilt 1968 · S/N P206-0561 N8763ZMacdonald John R · Vancouver, WABuilt 1968 · S/N P206-0563 N8773ZPolhamus Mark Trustee · Thompson Falls, MTBuilt 1969 · S/N P206-0573 N8774ZAero Squadron LLC · San Diego, CABuilt 1969 · S/N P206-0574 N8783ZAdventure Aircraft And Equipment LLC · Chelan, WABuilt 1969 · S/N P206-0583 N8787ZKing Farm Partnership · Mccrory, ARBuilt 1969 · S/N P206-0587 N8789ZParrott Charles F · Saugus, MABuilt 1969 · S/N P206-0589 N8792ZPerkovich Brian T · Oneida, WIBuilt 1969 · S/N P206-0592 N8795ZNeuschaefer George H · White Hills, AZBuilt 1969 · S/N P206-0595 N8797ZCjc Enterprises LLC · Erda, UTBuilt 1969 · S/N P206-0597 N8799ZMagnuson Robert L Jr · Mc Grath, AKBuilt 1969 · S/N P206-0599

Back to Cessna P206D