Skip to content

Registered aircraft · 170

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

N10133Fisher Charles R Jr · San Antonio, TXBuilt 1948 · S/N NAV-4-1766 N109DSBell Bradley L · Bothell, WABuilt 1948 · S/N NAV-4-1373 N182PGaines Robert M · Nashville, TNBuilt 1956 · S/N NAV-4-1246 N225ELetsom Steven D · Eugene, ORBuilt 1948 · S/N NAV-4-1160 N22VSchadler Alletta M · Fredericksburg, PABuilt 1949 · S/N NAV-4-866 N2882DPacific Coast Air Museum · Santa Rosa, CAS/N NAV-4-1938 N301Southwest Plane Holdings LLC · Kalispell, MTS/N NAV-4-1167 N3178GBrandt Goetz K · San Jose, CABuilt 1947 · S/N NAV-4-861 N3374GBangle Delbert F · El Cajon, CABuilt 1948 · S/N NAV-4-1280 N4008KOlson Eric C · Seattle, WABuilt 1947 · S/N NAV-4-1008 N4111KMillar Charles R · Maricopa, AZS/N NAV-4-1111 N4124KOtt Dean R · Carrollton, OHBuilt 1947 · S/N NAV-4-1124 N4126KNichols Jan L · Bonham, TXS/N NAV-4-1126 N4130KColvin Buster · Big Cabin, OKS/N NAV-4-1130 N4132KJohnston William D · Visalia, CAS/N NAV41132 N4135KBurlace Thomas J III · Aurora, COBuilt 1948 · S/N NAV-4-1135 N4139KStone Jason · Wellington, KSS/N NAV-4-1139 N4143KDerickson Russell J · Lamberton, MNBuilt 1948 · S/N NAV-4-1143 N4145KGerondale Gregory · Tulsa, OKS/N NAV-4-1145 N4146KHolmes Peter N · Spokane, WABuilt 1948 · S/N NAV-4-1146 N4150KTomlin Rollin D · Wilmington, OHBuilt 1949 · S/N NAV-4-1150 N4156KLohse Charles R · Onalaska, WAS/N NAV-4-1156 N4158KHester Jesse S · Mclean, VAS/N NAV-4-1158 N4169KAndersen Nicholas · Logan, UTS/N NAV-4-1169 N4183KGroth Matthew C · Arlington, WABuilt 1948 · S/N NAV-4-1183 N4188KMartino Victor H · Port Wentworth, GABuilt 1948 · S/N NAV-4-1188 N4190KPflaum Dudley T Trustee · Henderson, NVBuilt 1948 · S/N NAV-4-1190 N4193KPrice Steven C · Midland, TXBuilt 1948 · S/N NAV-4-1193 N4214KChristopher Michael L · Gerlach, NVBuilt 1948 · S/N NAV-4-1214 N4224KDickson Robert T · Charlotte, NCBuilt 1948 · S/N NAV-4-1224 N4230KHarper Paul V · Minerva, OHBuilt 1948 · S/N NAV4-1230 N4242KNaviation LLC · Kalispell, MTBuilt 1948 · S/N NAV-4-1242 N4244KKlungle William C · Grand Haven, MIBuilt 1948 · S/N NAV-4-1244 N4251KVlahakis Gregory G · San Jose, CABuilt 1948 · S/N NAV-4-1251 N4254KRankin Gary L · Meade, KSBuilt 1948 · S/N NAV-4-1254 N4255KWheeler Douglas A · Mount Vernon, OHS/N NAV-4-1255 N4262KBeaver Richard G · Spring, TXS/N NAV-4-1262 N4264KBejvan David E · Milwaukee, WIBuilt 1948 · S/N NAV-4-1264 N4267KStrength Vernon E · Eureka, CAS/N NAV-4-1267 N4271KMoeding Michael M · Emporia, KSBuilt 1948 · S/N NAV-4-1271 N4276KDunn Emet C III · Coolidge, AZBuilt 1948 · S/N NAV-4-1276 N4278KUrubek Raymond L · Refugio, TXBuilt 1948 · S/N NAV-4-1278 N4281KSperl Robert D · Keymar, MDBuilt 1948 · S/N NAV-4-1281 N4286KDeemer Jerry C · Granbury, TXBuilt 1948 · S/N NAV-4-1286 N4288KKrug III George R · Keller, TXS/N NAV-4-1288 N4289KForsberg Edwin E · Elk Grove, CABuilt 1948 · S/N NAV-4-1289 N4309KRezich James N · Winnebago, ILBuilt 1948 · S/N NAV-4-1309 N4312KJorsey Allen Jr · Reidsville, NCBuilt 1948 · S/N NAV-4-1312 N4317KEdwards Freeman Allen · Lake Butler, FLBuilt 1948 · S/N NAV-4-1317 N4323KRothfleisch Joseph Ryan · Brawley, CABuilt 1948 · S/N NAV-4-1323

Back to Ryan NAVION