Skip to content

Grumman American Avn. AA-1C

Registered aircraft · 102

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

N1047XHuber Frank B · Maple Grove, MNBuilt 1977 · S/N AA1C-0050 N119RCompton Danny M · Kent, OHBuilt 1978 · S/N AA1C0132 N11CYOdonnell Justin M · Amelia, OHS/N AA1C-0011 N121MPMast Anthony S · Ripon, CAS/N AA1C-0058 N137JBMason Harold T · Hesperia, CABuilt 1978 · S/N AA1C0207 N137YHenry Vernon C · Stevensville, MTBuilt 1978 · S/N AA1C0137 N1551RRegistration Pending · Plumas Lake, CARegistration pendingBuilt 1976 · S/N AA1B-0601 N15LMKleinert Keith · Alto, GABuilt 1977 · S/N AA1C0116 N177CTLancaster Clinton · Gainesville, FLS/N AA1C-0016 N213GDEdal Inc · Plantation, FLBuilt 1978 · S/N AA1C0145 N30NAPerryman Ronald William · Purmela, TXS/N AA1C-0010 N39006Captain Someday Inc · Wilmington, DES/N AA1C0180 N39007Cooper Sean Patrick Whittington · Walnut Creek, CABuilt 1978 · S/N AA1C0181 N39010Askew Stell B III · Durham, NCS/N AA1C0183 N39014Stegmann Scott A · Port Orange, FLFirst renewal noticeBuilt 1978 · S/N AA1C0184 N39016Fortnight Aviation LLC · Philadelphia, PABuilt 1978 · S/N AA1C0185 N39020Diegoli John E DBA · Camp Connell, CABuilt 1978 · S/N AA1C0188 N39021Landes Charles · Independence, ORS/N AA1C0189 N39022Hetem Steven · Atlantic Highlands, NJBuilt 1978 · S/N AA1C0190 N39030Wright Thomas · Bend, ORBuilt 1978 · S/N AA1C0193 N39038Stansberry Charles A · Saint Charles, MOBuilt 1978 · S/N AA1C0197 N39043Mcmahon Jamin T · Gig Harbor, WABuilt 1978 · S/N AA1C0201 N39046Paradis Robert J · Jackson, CABuilt 1978 · S/N AA1C0176 N39051Lynx Paw LLC · Wilmington, DEBuilt 1978 · S/N AA1C0204 N39058Karlin Dana M · Costa Mesa, CABuilt 1978 · S/N AA1C0206 N39064Fischer John W · Saint Charles, MOBuilt 1978 · S/N AA1C0210 N39065Kelly William A · Palmdale, CABuilt 1978 · S/N AA1C0211 N39070Wolff Karl W · Santa Fe, NMBuilt 1978 · S/N AA1C0143 N399XHlavin Mark S Trustee · Lakewood Ranch, FLBuilt 1978 · S/N AA1C0192 N4LUWalker Robert W · Cedar Hill, TNBuilt 1977 · S/N AA1C0033 N519QNewman C Keith · Cypress, TXBuilt 1978 · S/N AA1C0152 N6065BStohr Martin C · Palm Coast, FLBuilt 1978 · S/N AA1C0198 N73VMSecurcloud LLC · Castleton, NYBuilt 1978 · S/N AA1C0128 N8055WBarbulescu Marcel A · Arlington, VABuilt 1978 · S/N AA1C-0095 N855MPPerez Mario · Oak View, CABuilt 1978 · S/N AA1C0165 N872XGulfstream Aerospace Corp · Savannah, GABuilt 1972 · S/N AA1B-0087 N9514USwenson Roger A · Pahrump, NVS/N AA1C-0002 N9523UKpcw Grumman LLC · Port Clinton, OHBuilt 1977 · S/N AA1C0017 N9525UBaloo Flight Holdings LLC · Peoria, AZBuilt 1977 · S/N AA1C0019 N9526UHart Lewis W DBA · Rexburg, IDBuilt 1977 · S/N AA1C0020 N9528URegistered aircraftBuilt 1977 · S/N AA1C0024 N9530URegistered aircraftBuilt 1977 · S/N AA1C0026 N9531UClarke Adam M · Lompoc, CAS/N AA1C0027 N9532URosenkranz James H · Garland, TXBuilt 1977 · S/N AA1C0028 N9534UDavis Allen J · Weidman, MIS/N AA1C0030 N9538UMoxom Jeremy · Raleigh, NCBuilt 1977 · S/N AA1C0035 N9539UFletchair Inc · Comfort, TXBuilt 1977 · S/N AA1C0036 N9542UNorman Ronald Edward · Lopez Island, WAS/N AA1C0039 N9546UFletchair Inc · Comfort, TXBuilt 1977 · S/N AA1C0042 N9548UCharlton Daniel B · Frederick, MDBuilt 1977 · S/N AA1C0044

Back to Grumman American Avn. AA-1C