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.

N48WHElsea Incorporated · Circleville, OHS/N 3503 N4LRGreen Mark · Killeen, TXS/N 2002 N50280K&S Aviation LLC · Lewes, DES/N 352 N50BSSugiono Yudi S · Redlands, CABuilt 1946 · S/N 1118 N55QVolatilis LLC · Wilmington, DEBuilt 1946 · S/N 1024 N570SRRothstein Steven R · Punta Gorda, FLBuilt 1947 · S/N 2286 N57PCCutler Robert H · Denison, TXBuilt 1946 · S/N 1499 N58KBKientz William H Trustee · Chesterfield, MOBuilt 1946 · S/N 2216 N599ZSale Reported · Bertram, TXSale reportedBuilt 1946 · S/N 2058 N5BTJoseph Kenneth DBA · Canton, OHBuilt 1946 · S/N 2081 N619JMWeber Roger M · Independence, ORBuilt 1946 · S/N 1110 N61PKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1946 · S/N 1031 N65JGarrett Jeffery S · Waco, TXBuilt 1946 · S/N 360 N67BMOswin William R Jr · Newton, NJFirst renewal noticeS/N 1251 N685WHMarmic LLC · Russell, KSBuilt 1946 · S/N 149 N686TSLee Terence S · Luthersville, GABuilt 1946 · S/N 1091 N69JRMorgan Claude C Jr · Granada Hills, CABuilt 1946 · S/N 1287 N6LMGraf Peter B · Diamondhead, MSS/N 1211 N710NSo I Send You LLC · Cheyenne, WYBuilt 1946 · S/N 2139 N711NTMckee Thomas E · Terra Alta, WVS/N 1093 N76JBKilroy Kevin J · East Northport, NYBuilt 1946 · S/N 2010 N7764CJrh Trading LLC · Grapevine, TXBuilt 1946 · S/N 166 N77752Hovanec Nicki · Enterprise, FLBuilt 1948 · S/N 3524 N77757Taylor Jeffrey S · Cinnaminson, NJS/N 3529 N77767Abell Alan R · Elgin, ILS/N 1120 N77TKCc Motors LLC · Redding, CABuilt 1946 · S/N 2062 N77YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1946 · S/N 2278 N78000Fleurent Ronald G · Biddeford, MES/N 2004 N78006Johnson Mildred J Executor · Boerne, TXS/N 2006 N78007Abbott Cedric M · Buckfield, MEBuilt 1946 · S/N 2007 N78012Roberts James W · Knoxville, TNBuilt 1946 · S/N 2012 N78014Steward Drew C · Centerpoint, INBuilt 1946 · S/N 2014 N78023Via Interntional Inc · Reunion, FLBuilt 1946 · S/N 2023 N78024Robison James B · San Rafael, CAS/N 2024 N78028Planeview Aviation Services Inc · Ahoskie, NCBuilt 1946 · S/N 2028 N78030Price Stanley C · Grapevine, TXBuilt 1946 · S/N 2030 N78034C & C Aviation LLC · Leland, MSBuilt 1946 · S/N 2034 N78037Bartholomew Don · Gardnerville, NVBuilt 1946 · S/N 2037 N78038Ellingham Jeffrey B · Perry, GAS/N 2038 N78040Bednarek Michael H · Centerville, OHBuilt 1946 · S/N 2040 N78041Liu Weston B · Brookline, NHBuilt 1946 · S/N 2041 N78046Wilson Stephen A · Granbury, TXS/N 2066 N78048Latham Randall W · Georgetown, OHBuilt 1946 · S/N 2048 N78051Sipple Ronald W Jr · Gardner, KSS/N 2051 N78053Bartholomew Don · Gardnerville, NVBuilt 1946 · S/N 2053 N78055Lasko Peter · N Fort Myers, FLBuilt 1946 · S/N 2055 N78057Hampton Gerald N · Cameron Park, CABuilt 1946 · S/N 2057 N78067Phoenix Flyers LLC · Stillwater, MNBuilt 1946 · S/N 2067 N78068Carroll Judy Diane · Naples, FLBuilt 1946 · S/N 2068 N78069Holliday Mark E · Lake Elmo, MNBuilt 1946 · S/N 2069

Back to Globe GC-1B