Skip to content

Adams Balloon A55S

Registered aircraft · 35

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

N1059YZielinski Gary R · Gainesville, GABuilt 1982 · S/N 092 N1062GCanaday Bruce S · Woodstock, ILBuilt 1981 · S/N 078 N1062KJoslin James E · Emily, MNBuilt 1982 · S/N 103 N1062SDepew Michael P · Nashua, NHBuilt 1981 · S/N 082 N10634Olive Jonathan Scott · Albuquerque, NMBuilt 1982 · S/N 108 N10636What A Wind LLC · Mattawan, MIBuilt 1982 · S/N 111 N1063VFear Katrina Mj · Rio Rancho, NMBuilt 1982 · S/N 099 N1063YBeard Jeffrey M · Sedona, AZBuilt 1982 · S/N 109 N116FSLowenstein Albert L · Albuquerque, NMS/N 171 N1913GPayne Ralph J · Hastings, MIBuilt 1983 · S/N 122 N40206Reeder Eric L · Hastings, MIBuilt 1983 · S/N 129 N40229Dimmitt William C · Los Lunas, NMBuilt 1985 · S/N 162 N40302Moughan Peter Richard III · Milan, MIS/N 150 N40320Campbell Brittany R · Los Lunas, NMS/N 151 N4034AAbecca Corporation · Jackson, MIBuilt 1984 · S/N 140 N4034FMagee Brian T · Rochester, NYS/N 158 N4035PBristol David W · Sautee Nacoochee, GABuilt 1985 · S/N 154 N4035THawkins Charles W · Fairacres, NMBuilt 1984 · S/N 139 N4035YKerr Robert Charles · Mason, MIBuilt 1984 · S/N 145 N6000SKerr Robert C · Mason, MIS/N 56C200 N67008Hardin John M · Terrell, TXS/N 075 N79AZSparks Bobby G · Slatington, PAS/N 172 N9019ACowen David M · Corrales, NMS/N 017 N9023ADimmitt William C · Los Lunas, NMS/N 019 N9049AGunter Ryan S · Albuquerque, NMS/N 018 N9060AGunter Ryan S · Albuquerque, NMS/N 026 N9801NErickson Karl L · Hope, MEBuilt 1986 · S/N 0165 N9804NGauthier Travis G · Waterford, MIBuilt 1986 · S/N 170 N9805SDepew Michael P · Mechanicsburg, PAS/N 180 N9806NTrillanes Mark A · Albuquerque, NMBuilt 1986 · S/N 173 N9808SMartin Pamela M · Newnan, GAS/N 179 N98098Hodge Steven J · Tucson, AZS/N 189 N9812YBucket List Adventures LLC · Albuquerque, NMS/N 192 N9818JPayne Ralph J · Hastings, MIS/N 176 N9819QJones Dan E · Hilton Head Island, SCS/N 184

Back to Adams Balloon A55S