Registered aircraft · 26

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

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 ('89510T7', '89510T8', '89510T3', '89510TC', '89510TD', '89510TF', '89510UB', '89510S7', '89510S8', '89510TA', '89510TB', '89510TE', '89510TJ', '89510TU', '89510TZ', '89510UC', '89510S6', '89510TG', '89510TH', '89510TM', '89510TP', '89510TX', '89510TY') ORDER BY n_number

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 ('89510T7', '89510T8', '89510T3', '89510TC', '89510TD', '89510TF', '89510UB', '89510S7', '89510S8', '89510TA', '89510TB', '89510TE', '89510TJ', '89510TU', '89510TZ', '89510UC', '89510S6', '89510TG', '89510TH', '89510TM', '89510TP', '89510TX', '89510TY')
  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 ('89510T7', '89510T8', '89510T3', '89510TC', '89510TD', '89510TF', '89510UB', '89510S7', '89510S8', '89510TA', '89510TB', '89510TE', '89510TJ', '89510TU', '89510TZ', '89510UC', '89510S6', '89510TG', '89510TH', '89510TM', '89510TP', '89510TX', '89510TY')
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.

N1118MBrown Brent R · Edmond, OKBuilt 1970 · S/N 390 N11DC11dc LLC · Broomfield, COS/N 31 N12055Twigg John M · Pittsburgh, PABuilt 1974 · S/N 79 N1488Booth Mac E · Independence, ORS/N 303 N18JFFinney Bruce R · Yelm, WABuilt 1970 · S/N 262 N18JTBourget Marc J · Stockton, CABuilt 1972 · S/N 02 N18ZMays Paul R · Toney, ALBuilt 1971 · S/N 394 N198NFGuldi James E · Port Orange, FLS/N 587 N2287CKounovsky Jerry F · Tucson, AZBuilt 1967 · S/N 272 N249RFields Travis · Lees Summit, MOBuilt 1972 · S/N 06 N25002Ramsey Hudson Q · Cleburne, TXBuilt 1972 · S/N 257 N262PEPorter Randall L · Athol, IDBuilt 1971 · S/N 492 N2721Laney James R · Granbury, TXS/N 329 N2911Dewinter Thomas A · Waunakee, WIBuilt 1968 · S/N 86 N3098Feuerman Jerrold B · Denver, COBuilt 1972 · S/N 488 N312LLNilsen Christopher · Livermore, CABuilt 1964 · S/N 194 N338QJones Thomas P · Quartz Hill, CABuilt 1971 · S/N 70 N380GPaxton Ronald R · Colorado Springs, COBuilt 1972 · S/N 380 N4083BRoss Andrew P · Sparks, NVS/N 24 N427HKerr Kevin · Spring Hill, FLS/N 427 N4588Smithenry Eric J · Newton, ILBuilt 1973 · S/N 671 N4784GShinn Steven M Allen · Larkspur, COBuilt 1973 · S/N 131 N5661Bryant Billy Joe · Seymour, TNBuilt 1971 · S/N 588S N7199Big Sky Flyers LLC · Billings, MTBuilt 1971 · S/N 419F N76KRSorensen Bjarne K · Vero Beach, FLBuilt 1983 · S/N 353 N77AKRivers Paul E · Shannon, ILBuilt 1969 · S/N 390-A

Back to Thorp T-18