Skip to content

Registered aircraft · 63

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

N100FMajor Kens Flying Service LLC · Colfax, NDBuilt 1972 · S/N 1021 N10286Flying D Farm Inc · Kerhonkson, NYBuilt 1961 · S/N 86 N16AAMcpherson Timothy L · Page, NDBuilt 1971 · S/N 792 N27SKKingsley Kiman J · Miller, MOBuilt 1974 · S/N 1341 N410XBas Part Sales LLC · Greeley, COBuilt 1969 · S/N 631 N4244Kingsley Kiman J · Miller, MOBuilt 1973 · S/N 1034 N4728Porter Flying Service Inc · Chico, CAS/N 1089 N4757Double D Flying Service Inc · Leesburg, GABuilt 1973 · S/N 1091 N5272Lanier John L Jr · Madison, ALS/N 652 N5275Flying D Farm Inc · Kerhonkson, NYS/N 561 N5279Vanderwaal Shane J · Junction City, WIBuilt 1968 · S/N 564 N5286Slikker Flying Service Inc · Buttonwillow, CABuilt 1968 · S/N 562 N5291Sky Aviation Corp · Worland, WYBuilt 1968 · S/N 572 N5301P M Dusters Inc · Durham, CABuilt 1969 · S/N 590 N5303Valley Sprayers Inc · Park River, NDBuilt 1969 · S/N 577 N5327Farm Air Inc · Astoria, ILBuilt 1969 · S/N 595 N5335Williams Ag Service · Biggs, CABuilt 1969 · S/N 603 N5337Mcdonald Jake V · Bowling Green, MOS/N 628 N5344Graf Eric L · Dolores, COBuilt 1969 · S/N 619 N5346Lanier Flying Service Inc · Madison, ALBuilt 1969 · S/N 643 N5366Haynes Robert K · Pilot Point, TXBuilt 1969 · S/N 646 N5368Cw Equipment Rentals Inc · Biggs, CABuilt 1969 · S/N 648 N5369Ag Air II LLC · Scott, MSBuilt 1969 · S/N 649 N5412N5412 LLC · Shawnee, OKBuilt 1973 · S/N 1025 N5416Nelson Flyers Inc · Louise, TXS/N 1030 N54EZZavala Edward R · Tahoka, TXBuilt 1975 · S/N 1597 N600JSRiggin Flight Service Inc · Madison, SDS/N 835 N600TCarlson Cory R · Trail, MNBuilt 1969 · S/N 600 N606YButte County Mosquito & Vector Control District · Oroville, CABuilt 1963 · S/N 229 N622AGIngalls Aerial Sprayers Inc · Ingalls, KSS/N 622 N6535Vanderpool Gary W · Alamo, TXBuilt 1969 · S/N 683 N6538Holtz Britton N · Clarksburg, CABuilt 1969 · S/N 670 N6542Hanke Kenneth O · Clio, SCBuilt 1969 · S/N 682 N6547Page Elbert DBA · Clio, SCBuilt 1969 · S/N 695 N6548Petersen Jacob · Tyler, MNBuilt 1969 · S/N 692 N6553Tall Towers Aviation Inc · Page, NDBuilt 1970 · S/N 696 N6565Ag Air Inc · Raceland, LABuilt 1970 · S/N 722 N6569Sale Reported · Friedenburg, PASale reportedBuilt 1970 · S/N 709 N6583Schwend Brian DBA · Forsyth, MTBuilt 1970 · S/N 720 N6594Smith David C · Malott, WABuilt 1970 · S/N 733 N6627Richter Aviation Inc · Maxwell, CABuilt 1970 · S/N 757 N700MCHanke Kenneth O · Clio, SCBuilt 1970 · S/N 700 N7849Sale Reported · Pelkie, MISale reportedS/N 797 N7855S&D Aviation LLC · Pamplico, SCS/N 803 N7856Tri State Aero Inc · Martinsburg, WVBuilt 1971 · S/N 805 N7902Vanderpool Gary W · Alamo, TXBuilt 1971 · S/N 808 N7930Ham Orlando M · Opdyke, ILBuilt 1971 · S/N 816 N7958Lipscomb G Gerald · Magnolia Springs, ALBuilt 1971 · S/N 837 N895XGustin Aviation Inc · Lewiston, IDBuilt 1965 · S/N 401 N896XMajor Ken'S Flying Service LLC · Colfax, NDBuilt 1967 · S/N 451

Back to Grumman G-164A