Skip to content

Registered aircraft · 37

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

N2127CRowsey Andrew M · Corinth, MSBuilt 1959 · S/N 7GC-50 N4831EHardy John R · Wasilla, AKBuilt 1959 · S/N 7GC-39 N4832ESenn David L · Oak Ridge, TNBuilt 1959 · S/N 7GC-40 N4844EGroves Jamie L · Wasilla, AKBuilt 1959 · S/N 7GC-44 N4850EGibson Timothy A · Frankfort, KYBuilt 1959 · S/N 7GC-47 N4866ECollier Charles R · Gloucester, VABuilt 1959 · S/N 7GC51 N4871ESloss John W · Sterling, AKS/N 7GC-76 N4876EFarrell Clifton S · Needville, TXBuilt 1959 · S/N 7GC-55 N4879EPappas William B · Dallas, TXBuilt 1959 · S/N 7GC56 N4882EWalker Ray A · Sanger, TXBuilt 1959 · S/N 7GC-59 N4883ECarricaburu Elliot A · Wasilla, AKS/N 7GC-60 N4894EPlyler Aviation Lp · Sherman, TXBuilt 1959 · S/N 7GC-68 N49DTClark Coy A · Raeford, NCBuilt 1957 · S/N 7FC-117 N5923LKane Christopher M · Sacred Heart, MNS/N 7GC-80 N597GCAg-Av8r Flying Services LLC · Brookline, NHBuilt 1959 · S/N 7GC-72 N621EHofstetter Michael T · Saint James, MOS/N 7-GC-46 N650GSDiebel Darrel L · Okanogan, WABuilt 1958 · S/N 7GC91 N7411BWilcox Stacy S · Parker, COBuilt 1956 · S/N 7EC-443 N7572ENibbe Douglas L · Saint James, MNBuilt 1958 · S/N 7GC-15 N7574EWalpierre LLC · Indiana, PABuilt 1958 · S/N 7GC-17 N7587EBroderick William E · Sterling, MABuilt 1958 · S/N 7GC-19 N7591EYoung Carl J · Lubbock, TXBuilt 1958 · S/N 7GC-24 N7595EFlynn Andrew L · La Grande, ORBuilt 1958 · S/N 7GC-29 N777UFTaylor Douglas M · Dallas, TXBuilt 1960 · S/N 166 N836ZRegistered aircraftS/N 138 N848XAnderson Charles E · Fort Worth, TXBuilt 1959 · S/N 7GC58 N8502EJones Derick · Moultonborough, NHS/N 7GC-71 N8507ERifenburg Brian K · Ward Cove, AKS/N 7GC-75 N8547ECarpenter Lionel Lee · South Fork, COBuilt 1959 · S/N 7GC-98 N8549EDrageset Denvero · Isabel, SDS/N 7GC-99 N8578EDamrow L Bruce · Jay Em, WYBuilt 1959 · S/N 7GC-132 N8924RMachler Lance J · Murphys, CABuilt 1959 · S/N 152 N8933RThrall Gregory D · Seward, AKBuilt 1959 · S/N 7GC-159 N8947RUpton Chris M · Hettinger, NDBuilt 1960 · S/N 7GC163 N8948RWhomble Leonard L · Wray, COBuilt 1960 · S/N 7GC-164 N8949RMorten Jesse L · Larimore, NDBuilt 1960 · S/N 7GC-165 N9127RRegistered aircraftBuilt 1958 · S/N 7GC-14

Back to Champion 7GC