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.

N1005KKing Richard J II · Rose Creek, MNBuilt 1946 · S/N 3732 N1013KBall Jeffrey A · Harrison, ARBuilt 1946 · S/N 3740 N1015KMichaud Paul · Forest Lake, MNBuilt 1946 · S/N 3742 N1029KCrabbe Michael B · Galloway, OHBuilt 1946 · S/N 3756 N1034KSpivey Harold E · Thomaston, GABuilt 1946 · S/N 3761 N1035KDrake Thomas E · Phoenix, AZBuilt 1946 · S/N 3762 N1040KKoons Brian D · Canton, OHBuilt 1946 · S/N 3767 N1042KCorporate Aircraft Leasing Co · Newton Falls, OHS/N 3769 N1045KWilder Kirk E · Boonville, CABuilt 1946 · S/N 3772 N1046KCuny John B · Carlsborg, WABuilt 1946 · S/N 3773 N1057KLips Paul A · Waxahachie, TXBuilt 1946 · S/N 3784 N1064KStein Andrew · Modesto, CABuilt 1946 · S/N 3791 N1072KAlley Shane C · Jackson, MOS/N 3799 N1080KLindsey Harold D · Wichita Falls, TXBuilt 1946 · S/N 3807 N1082KBoese Erich DBA · Oakdale, CABuilt 1946 · S/N 3809 N1087KMiller Robert L III DBA · Kittrell, NCBuilt 1946 · S/N 3814 N1088KTaylor Spencer H · Lake City, FLBuilt 1946 · S/N 3815 N1091KThompson Isaac R · Stoutsville, OHBuilt 1946 · S/N 3818 N1097KWerner Glenn M · Hartwell, GABuilt 1946 · S/N 3824 N1100KWilkie David J · Nashua, NHBuilt 1946 · S/N 3827 N1101BMchugh Ronna R · Salem, ORBuilt 1947 · S/N 5728 N1104BTimmons Colton R · Yuma, AZBuilt 1947 · S/N 5731 N1104KJohnson Christopher · Danville, INBuilt 1946 · S/N 3831 N1107BBacon Joseph M · Fenton, MIBuilt 1947 · S/N 5734 N1107KButtonwillow Land & Cattle Co · Buttonwillow, CABuilt 1946 · S/N 3834 N1109KCard William N III · Schwenksville, PABuilt 1946 · S/N 3836 N1116BRogers Douglas M · Milwaukee, WIBuilt 1947 · S/N 5743 N1116KSexton Robert D · Sugar Grove, VAS/N 3843 N1117BAnderson Marlin R · Malta, ILBuilt 1947 · S/N 5744 N1125BHansen Michael L · Williamson, GABuilt 1947 · S/N 5752 N1126KBrushwitz Ronald C Jr · Salem, ILBuilt 1946 · S/N 3853 N1128KMitchell Peter J · Concord, CABuilt 1946 · S/N 3855 N1131BBurnett Ronald L · Dardenne Prairie, MOBuilt 1947 · S/N 5758 N1136BLambasio Francis T · Canton, ILBuilt 1947 · S/N 5763 N1139BJohnston Lance M · Bellingham, WABuilt 1947 · S/N 5766 N1139KClairday Joey · Melbourne, ARBuilt 1946 · S/N 3866 N1142BWood Ross H · Stuttgart, ARBuilt 1947 · S/N 5769 N1143BBaker Joseph P · Matthews, NCBuilt 1947 · S/N 5770 N1147KYoung Frank M · Lompoc, CABuilt 1946 · S/N 3874 N1150KLinscheid Glen A · Tillamook, ORBuilt 1946 · S/N 3877 N1153BHultzapple Ted D · Farmington, NYS/N 5780 N1155BColeman William C · Somerset, OHS/N 5782 N1160KDenney Mark J Trustee · Battlefield, MOBuilt 1946 · S/N 3887 N1164KGoode Stephen C · Canton, TXBuilt 1946 · S/N 3891 N1165BSpivey Kenneth R Jr · Vestavia, ALS/N 5792 N1167BMurley Stephen L · Boerne, TXBuilt 1947 · S/N 5794 N1167KCowger Steven J · Harrisonburg, VABuilt 1946 · S/N 3894 N1170KDaw Brian W · Monmouth, ILBuilt 1946 · S/N 3897 N1171KWiebe James R · Valley Center, KSBuilt 1946 · S/N 3898 N1174KWoodburn Thomas J · Glen Allen, VABuilt 1946 · S/N 3901

Back to Luscombe 8A