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.

N71988St Onge Robert J · Sterling, AKBuilt 1946 · S/N 3415 N71997Campbell Edward J · Chandler, OKBuilt 1946 · S/N 3424 N71998Sink Lendon V · Lexington, NCS/N 3425 N72000Muser Michael · Rockford, ILS/N 3427 N72005Kerr Jerry T · Mount Vernon, WABuilt 1946 · S/N 3432 N72009Bolton Derwin B · Jacksonville, TXBuilt 1946 · S/N 3436 N72011Boyce Michael C · Shelby, OHBuilt 1947 · S/N 5285 N72012Neeper James P · Fayetteville, NCBuilt 1946 · S/N 3439 N72022Sutton John S · Birmingham, ALBuilt 1946 · S/N 3449 N72029Nicols Bruce D · Titusville, PABuilt 1946 · S/N 3456 N72031Jaworski Roger W · Mesa, AZBuilt 1946 · S/N 3458 N72032Aero Missions Inc · Sylacauga, ALBuilt 1946 · S/N 3459 N72043Econo Rate Rent A Car Inc · Windsor, COS/N 3470 N72051Deckard Steven W · Wellington, NVBuilt 1946 · S/N 3478 N72056Allen Thomas R · Kalispell, MTBuilt 1946 · S/N 3483 N72057Jackson Lee R · Baldwinsville, NYBuilt 1946 · S/N 3484 N72058Gorst Wayne R · Colville, WABuilt 1946 · S/N 3485 N72059Ramin Jeanette J · Houston, TXBuilt 1946 · S/N 3486 N72064Pyland Jack W · Seagoville, TXBuilt 1946 · S/N 3491 N72065Henderson James E · Greenville, TXS/N 3492 N72070Western Antique Aeroplane & Automobile Museum · Hood River, ORS/N 3497 N72071Marcoski Edward T · Downers Grove, ILBuilt 1946 · S/N 3498 N72072Tidball Paul Jon · Molalla, ORBuilt 1946 · S/N 3499 N72080Eldred Thomas A · Jupiter, FLBuilt 1946 · S/N 3507 N72085Halpin John Hadden III Trustee · Sasakwa, OKBuilt 1946 · S/N 3512 N72087Letkeman John K · Seminole, TXBuilt 1946 · S/N 3514 N72090Davenport Ross K · Raleigh, NCS/N 3517 N72095Peterson Andrew B · Louisville, KYS/N 3522 N72097Sills Gary Michael · Waxahachie, TXBuilt 1946 · S/N 3524 N7220TVipond Andrew · Ormond Beach, FLBuilt 1949 · S/N 6439 N73851Igoe James J Jr · Cincinnati, OHS/N 4293 N74334Schmiedt Daniel M · Westminster, SCBuilt 1946 · S/N 2761 N770Yates Cecil R · Westminster, CABuilt 1946 · S/N 4037 N77803Lor Dara H · Breckenridge, COS/N 3530 N77806Gordon Jerry D · Sunset Beach, NCBuilt 1946 · S/N 3533 N77807Taylor Benton A · Baldwin City, KSBuilt 1946 · S/N 3534 N77808Sterner Robert E · Kettle Falls, WABuilt 1946 · S/N 3535 N77809Kingsley Kiman J · Miller, MOBuilt 1946 · S/N 3536 N77810Registration Pending · Norwalk, IARegistration pendingBuilt 1946 · S/N 3537 N77819Deakyne Carl T · Federalsburg, MDBuilt 1946 · S/N 3546 N77822Sibley Kevin W · Porter, TXBuilt 1946 · S/N 3549 N77837Bolton Derwin B · Jacksonville, TXS/N 3564 N77838Sparks Robert B · Alexandria, LABuilt 1946 · S/N 3565 N77841Delaware Sport Flyers Inc · Farmland, INBuilt 1946 · S/N 3568 N77842Lynch Darrell L · Lawton, OKBuilt 1946 · S/N 3569 N77854Sierens James J · Palmetto Bay, FLBuilt 1946 · S/N 3581 N77856Gregory Norb L · Farmington, MNBuilt 1946 · S/N 3583 N77857Gehring Dennis M · White Bear Lake, MNFirst renewal noticeBuilt 1946 · S/N 3584 N77861J P Aero Holdings Inc · Carson City, NVS/N 3588 N77863Heinz Kenneth P · Broadway, VABuilt 1946 · S/N 3590

Back to Luscombe 8A