Skip to content

Registered aircraft · 897

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 ('8190104', '8190111')
  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 ('8190104', '8190111')
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.

N71535Wood Stephen K · Whitewater, COBuilt 1946 · S/N 2962 N71537Allen Roger M · Salem Lakes, WIBuilt 1946 · S/N 2964 N71540Murphy Frank · Thomasville, GAS/N 2967 N71541Crowley Jeffrey B · Newnan, GAS/N 2968 N71547Pratt Adam D · Shawnee, KSS/N 2974 N71549Sodergren Kit · Davis, CABuilt 1946 · S/N 2976 N71555Whaley Paul W · El Dorado, KSBuilt 1946 · S/N 2982 N71556Hood Matthew G · Argyle, TXBuilt 1946 · S/N 2983 N71567Bennett George G · San Augustine, TXBuilt 1946 · S/N 2994 N71574Almena State Bank · Almena, KSBuilt 1946 · S/N 3001 N71575Pyle William V · Sun Prairie, WIBuilt 1946 · S/N 3002 N71577Fugate Terry L · Atoka, OKBuilt 1946 · S/N 3004 N71586Anderson Mark A · Bates City, MOBuilt 1946 · S/N 3013 N71600Morrissey John C · Lees Summit, MOBuilt 1946 · S/N 3027 N71603Hallstrom Warren C · North Little Rock, ARBuilt 1946 · S/N 3030 N71608Perunko Daniel R · Grass Valley, CABuilt 1946 · S/N 3035 N71615Goetz Thomas J · Woodland, MEBuilt 1946 · S/N 3042 N71628Mccormick Edward J Jr · Kenton, OHBuilt 1946 · S/N 3055 N71632Landsgaard Theodore J · Rosamond, CABuilt 1946 · S/N 3059 N71635Swift Timothy G · Washington, IAS/N 3062 N71643Mccain Rod A · El Cajon, CAS/N 3070 N71647Mehrdad Zarifkar · Mount Vernon, IABuilt 1946 · S/N 3074 N71660Ramin Jeanette J · Houston, TXBuilt 1946 · S/N 3087 N71662Chapin William V · Fayetteville, GABuilt 1946 · S/N 3089 N71668Lovley Vaughn T · Webster, MNBuilt 1946 · S/N 3095 N71676Johnson Jimmy L · Saint Charles, MOBuilt 1946 · S/N 3103 N71686Dubbert Roger · Mexico, MOBuilt 1946 · S/N 3113 N71688Ott Edward C · Walnut Creek, CABuilt 1946 · S/N 3115 N71691Burka Mark A · Finchville, KYBuilt 1946 · S/N 3118 N71692Mccoy Kenneth L Jr · Syria, VAS/N 3119 N71694Driscoll Patrick J · Caldwell, IDBuilt 1946 · S/N 3121 N71698Kaurich Steven J · O Brien, FLS/N 3125 N71704Maxwell Steven L · Safford, AZS/N 3131 N71708Sievert Stephen L Sr · Plainfield, ILBuilt 1946 · S/N 3135 N71711Mohrbacher Dale A · Naples, FLBuilt 1946 · S/N 3138 N71712Oshins Lawrence W · Gainesville, FLBuilt 1946 · S/N 3139 N71715Gelbart Uriel A · Anchorage, AKS/N 3142 N71717Bradford William F · Independence, MOBuilt 1946 · S/N 3144 N71718Johnson Bonnie L · Sedgwick, KSBuilt 1946 · S/N 3145 N71732Flemming Richard Eric · Kinsman, OHS/N 3159 N71734Registration Pending · Lakemont, GARegistration pendingS/N 3173 N71738Laroche John A · Ellington, CTBuilt 1946 · S/N 3165 N71750Rushing Kevin W · Marks, MSS/N 3177 N71760Schrage Jay T · Allison, IABuilt 1946 · S/N 3187 N71765Stephen M Henley · Lexington, NCBuilt 1946 · S/N 3192 N71771Mccartney Scott L · Plymouth, INBuilt 1946 · S/N 3198 N71780Registration Pending · Lafayette, LARegistration pendingBuilt 1946 · S/N 3207 N71781Smith William Lee · Langley, WAFirst renewal noticeBuilt 1946 · S/N 3208 N71789Peterson Richard L · Crook, COBuilt 1946 · S/N 3216 N71790Christy Ronald P · Covert, MIS/N 3217

Back to Luscombe 8A