Skip to content

Registered aircraft · 144

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

N1010QBurklund Joel H · Minneapolis, MNBuilt 1970 · S/N 27370 N11090Lohr Martin J · Petersburg, AKBuilt 1966 · S/N 35 N111BE7gcbeec LLC · Boise, IDBuilt 1970 · S/N 277-70 N1610GVeenstra Timothy S · Wasilla, AKS/N 114 N1625GPippert Jim · Dysart, IABuilt 1968 · S/N 127 N1649GBentley Kyle S · Keene, NHBuilt 1968 · S/N 120 N1652GRunway 5 LLC · Wurtsboro, NYBuilt 1968 · S/N 122 N1654GGelvin Stanley M · Central, AKBuilt 1968 · S/N 123 N1670GKing John D · Midland, VABuilt 1968 · S/N 137 N1691GPalmer Christopher John · Upper Lake, CABuilt 1968 · S/N 134 N1692GSmith Theodore M · Van Buren, MES/N 135 N16RGHomer Ace Inc DBA · Tulsa, OKBuilt 1969 · S/N 205 N17JCHigh Wing Aviation LLC · Sardis, MSBuilt 1969 · S/N 164 N1804GKrenzke Stephen E · Fairbanks, AKBuilt 1968 · S/N 100 N1826GSelting Mark D · Kadoka, SDBuilt 1968 · S/N 102 N1828Van Nice Alexander W · Wasilla, AKS/N 101 N1856GGray Timothy V · Clearbrook, MNS/N 12 N1863GGriffin Robert G · Anchorage, AKS/N 108 N1868GBrown Kirk W · Spring Branch, TXBuilt 1968 · S/N 109 N1880GSchool Of Missionary Aviation Technology · Ionia, MIBuilt 1968 · S/N 50 N1887GJewett Cody C · Isabel, SDBuilt 1968 · S/N 117 N21262Aysta Nathan P · Hermantown, MNBuilt 1968 · S/N 130 N225QZHoward Alan L · Leeds, UTBuilt 1969 · S/N 138 N24MKPiispanen Norman C · Fairbanks, AKBuilt 1969 · S/N 151 N2531FFishwick Steve K · Hamilton, OHBuilt 1966 · S/N 22 N2547FAysta Paul M · Embarrass, MNBuilt 1966 · S/N 48 N2586GJeppesen Thomas L · Stanton, MIS/N 7 N25KRBrothers Aviation LLC · Black Rock, ARBuilt 1970 · S/N 274-70 N268JGSpero Bruce A · Carson City, NVS/N 4 N2712GGrady'S Auction & Realty Inc · Newport, ARBuilt 1967 · S/N 14 N2727GTetrad Corp DBA · Lusk, WYBuilt 1967 · S/N 10 N2828GSparrow Hawk Aviation LLC · Moraine, OHS/N 84 N2831GJohnston Skippy W · Fairbanks, AKBuilt 1967 · S/N 57 N2951GFletcher Flying Service 419 LLC · Labelle, FLBuilt 1967 · S/N 62 N2993GKilgore Samuel E Jr · Southaven, MSBuilt 1967 · S/N 54 N3059GStulp Annessa C · Lamar, COBuilt 1968 · S/N 37 N3071GWetherbee Steven R · Pollock, SDBuilt 1967 · S/N 98 N3085GRegistration Pending · Wasilla, AKRegistration pendingBuilt 1968 · S/N 91 N31SCObryant Jeffrey A · Fairbanks, AKBuilt 1967 · S/N 79 N333YZeller Ty F · Trego, WIBuilt 1969 · S/N 7GCBC-194 N33DVKostreva Adam · Riverton, WYBuilt 1970 · S/N 234-70 N3464DHenricks Aero LLC · Eatonville, WABuilt 1969 · S/N 168 N348LADirks Brandon D · Ludell, KSS/N 69-146 N386ASSandstrom Allan A · North Ogden, UTBuilt 1970 · S/N 220-70 N39DBKwasinski Mark W · Kalamazoo, MIBuilt 1969 · S/N 153 N4333KWeisbeck Kenneth J · Scottsdale, AZS/N 115-2 N469KLM9 Flight LLC · Delhi, LABuilt 1966 · S/N 61 N5074XBaker Jim · Hermosa, SDBuilt 1969 · S/N 40 N5075XOpjorden Chris T · Litchfield, MNS/N 139 N5076XPalmer Bryce P · Chugiak, AKBuilt 1968 · S/N 140

Back to Champion 7GCBC