Skip to content

Registered aircraft · 394

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

N3245KAdair Edward A · Hemet, CAS/N 1238 N3246KRiggins Construction LLC · Show Low, AZBuilt 1946 · S/N 1239 N3247KKroll Cody A · Cincinnati, OHS/N 1240 N3248KEngel Eberhard E · Northfield, MNBuilt 1946 · S/N 1241 N3252KCrnic Paul C · Chesterfield, MOBuilt 1946 · S/N 1245 N3253KWarbird Adventures Inc · Ocoee, FLS/N 1246 N3256KCreager Wes L Md · Hopkinsville, KYFirst renewal noticeBuilt 1946 · S/N 1249 N3257KKrueger Hendrick · Rockport, TXS/N 1250 N3267KShay John D · Covina, CABuilt 1946 · S/N 1260 N3269KJones Michael R · Riverside, CABuilt 1946 · S/N 1262 N3271KCameron Reginald B · Cumberland, MEBuilt 1946 · S/N 1264 N3283KSchultz John G · Independence, ORBuilt 1946 · S/N 1276 N3285KWoelbing Aviation LLC · Franksville, WIBuilt 1946 · S/N 1278 N3288KZahler Mitchell J · Stillwater, MNS/N 1281 N3289KWayman Ian A · Peyton, COBuilt 1946 · S/N 1282 N3293KLegarra Mark · Redding, CAS/N 1286 N3296KSwift Museum Foundation Inc · Athens, TNBuilt 1946 · S/N 1289 N3297KElevate780 LLC · Burlington, WIBuilt 1946 · S/N 1290 N3301KHarrison George B · Peachtree City, GABuilt 1956 · S/N 1294 N3304KTomerlin Erin G · Napa, CABuilt 1946 · S/N 1297 N3307KArbeau Denis M · Napa, CABuilt 1946 · S/N 1300 N3308KHowell Harley L Jr · Colville, WABuilt 1946 · S/N 1301 N3311KBartholomew Donald B · Gardnerville, NVBuilt 1946 · S/N 1304 N3312KGass William D Trustee · Mountain View, CABuilt 1946 · S/N 1305 N3313KMckenney Bret K · Billings, MTS/N 1306 N3315KBauerle Gerald F · Hammond, LABuilt 1946 · S/N 1308 N3318KMace Wade L · Ottawa, KSS/N 1311 N3321KReiff Christopher R · Mansfield, MABuilt 1946 · S/N 1314 N3323KBurrous Peter M · Mount Pleasant, SCBuilt 1946 · S/N 1316 N3325KBartholomew Don · Gardnerville, NVBuilt 1946 · S/N 1318 N3327KBornheber Raif · DraskovicS/N 1320 N3329KCalifornia Antique Aircraft Museum DBA · San Martin, CABuilt 1946 · S/N 1322 N3331KWright Wayne M · Chestertown, MDFirst renewal noticeBuilt 1946 · S/N 1324 N3333KOrtet Jon · Valley Springs, CABuilt 1946 · S/N 1326 N333DKMalinchak Louis Trustee · Bristow, OKBuilt 1946 · S/N 2157 N3343KSel LLC · Dover, DEBuilt 1946 · S/N 1336 N3344KKremmling Flying Inc · Kremmling, COS/N 1337 N3348KTribley Lori J · Magnolia, TXBuilt 1948 · S/N 1341 N3351KBartholomew Don B · Gardnerville, NVS/N 1344 N3357KNewman Steve M · Portland, ORS/N 1350 N3366KWilson Stephen A · Granbury, TXBuilt 1946 · S/N 1359 N3368KFink Jeffrey C K · Austin, TXBuilt 1946 · S/N 1361 N3370KMinor James F · Lake Dallas, TXBuilt 1946 · S/N 1363 N3371KRengstorf Larry · Windsor, CAS/N 1364 N3378KGarcia Michael J · La Verne, CABuilt 1946 · S/N 1371 N3380KKabat Jules Max · Las Vegas, NVBuilt 1946 · S/N 1373 N3385KSalmonsen James A · Oswego, NYBuilt 1946 · S/N 1378 N3390KFowler Darrel D Trustee · Las Vegas, NVBuilt 1946 · S/N 1383 N3393KAnderson James · Saint Onge, SDS/N 1386 N3395KWoxof LLC · Advance, NCBuilt 1946 · S/N 1388

Back to Globe GC-1B