Skip to content

Registered aircraft · 114

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

N6358NLarson Lynn R · Fargo, NDBuilt 1967 · S/N 6 N6366NCarlson Eric S · Kodiak, AKBuilt 1967 · S/N 15 N6368NS&S Aviation LLC · Morse, LABuilt 1969 · S/N 161 N6385NDewitt Robert M · Maybee, MIBuilt 1967 · S/N 111 N6388NAugust Aero LLC · Kalispell, MTS/N 165 N6399NMcguire Zach T · Jasper, MOBuilt 1967 · S/N 171 N6726NBritsch Uwe K DBA · Klamath Falls, ORBuilt 1967 · S/N 167 N6857STailgate LLC · Felton, GABuilt 1968 · S/N 183 N690SHCorriher Mark B · Mocksville, NCBuilt 1966 · S/N 132 N7456GGregory Larry C Trustee · Farmington, MOS/N 129 N7501FStafford Tech Inc · Rehoboth, MABuilt 1969 · S/N 204 N7554FJohnson Michael L · Jefferson, TXS/N 206-70 N7559FDodge Donald V · Newnan, GAS/N 208-70 N7574FDriskill Larry W · Lubbock, TXBuilt 1969 · S/N 209-70 N7591FFinger Lakes Soaring Club Inc · Dansville, NYFirst renewal noticeBuilt 1970 · S/N 210-70 N79QBBaer Marcus R · Aubrey, TXBuilt 1965 · S/N 48 N829JBMathis Robert · Sandersville, GABuilt 1965 · S/N 34 N8305VBell Anthony J · Avondale, AZBuilt 1966 · S/N 98 N8309VSunde Bradley J · Fergus Falls, MNBuilt 1966 · S/N 95 N8317VLynch Gerald C · Collinsville, OKBuilt 1966 · S/N 84 N8320VThurman Randall N · Mcminnville, ORBuilt 1966 · S/N 399 N8322V11 Point Aviation LLC · Alton, MOBuilt 1966 · S/N 65 N8329VBuck Timothy A · Howland, MES/N 119 N8346VLovley Linda C · Jordan, MNBuilt 1966 · S/N 127 N8357VHaas Daniel S · Camarillo, CABuilt 1966 · S/N 136 N8371VPrairie Thermals LLC · Brookings, SDBuilt 1966 · S/N 82 N8373VSeidler Marlyn L · Underwood, NDBuilt 1966 · S/N 121 N8391VRoflyco Ltd · Glendale, AZBuilt 1966 · S/N 107 N85551Hanson Shirley M · Pentwater, MIBuilt 1946 · S/N 7AC-4291 N9005LColorado Twin Bonanza LLC · Broomfield, COBuilt 1970 · S/N 212-70 N9021LRobert Rees · Jonesboro, ARS/N 214-70 N9030LDavis Robert L · Seymour, TNBuilt 1970 · S/N 216-70 N9047LDaniel Bryan G · Childress, TXS/N 217-70 N9058LLucius William C · Moosic, PABuilt 1970 · S/N 220-70 N9062LR & B Helicopters Inc · Calhoun, GABuilt 1970 · S/N 221-70 N9081LReed William B Trustee · San Jose, CABuilt 1970 · S/N 224-70 N9085LBlanton Jeffrey D · Valley Center, KSBuilt 1970 · S/N 226-70 N9093LBielamowicz John Kolbe · Waxahachie, TXBuilt 1970 · S/N 228-70 N9128LSmith Stuart T · Murrieta, CAS/N 199-71 N9146LMalone Aaron E · Wasilla, AKS/N 812-71 N9520SPease Richard C · Snow Camp, NCBuilt 1965 · S/N 8 N9536SExpress Aviation LLC · Philadelphia, MSBuilt 1966 · S/N 94 N9537SHowell Alice R · Bainbridge, GABuilt 1965 · S/N 23 N9552SSmith Ranch Inc · Broadus, MTBuilt 1965 · S/N 42 N9558SKansas Air LLC · Linn, KSS/N 39 N9561SFerguson Glen P · Cascade, MTS/N 56 N9573SOppegard Nicholas D · Eagle River, AKBuilt 1966 · S/N 66 N9574SKrejchik Daniel J · Portage, WIBuilt 1965 · S/N 14 N9587SReberg Timothy J · Bayport, MNBuilt 1965 · S/N 5 N9589SJones Daniel S · Panama City Beach, FLBuilt 1965 · S/N 9

Back to Champion 7GCAA