Skip to content

Registered aircraft · 543

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 ('2076405', '2073325')
  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 ('2076405', '2073325')
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.

N533WPJacobs Aviation LLC · Mt Juliet, TNS/N 340A0328 N5340GLegal Limit Motor Sports LLC · Anderson, CAS/N 340A0421 N5346JCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1977 · S/N 340A0419 N535KWFlying Squirrel Aviation LLC · Bozeman, MTS/N 340A0710 N5421JPeruzzi John DBA · Los Angeles, CABuilt 1976 · S/N 340A0108 N542MNKeeler Aviation LLC · Plattsmouth, NEFirst renewal noticeBuilt 1976 · S/N 340A0109 N5432JSouthampton Wing LLC · Southampton, NYBuilt 1976 · S/N 340A0110 N543DGrantham Ray · Sevierville, TNBuilt 1984 · S/N 340A1805 N5446GCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1979 · S/N 340A0685 N5453JC L Flight Associates LLC · Bakersfield, CAS/N 340A0111 N5454XKair Aviation · Parkland, FLS/N 340A1512 N545MMage Aircraft Leasing LLC · San Antonio, TXS/N 340A1041 N54GSN28hb LLC · New York, NYS/N 340A0456 N550SNortheast Cubs LLC · Wilmington, DEBuilt 1976 · S/N 340A0086 N555CPFirebird Air LLC · Fulshear, TXBuilt 1979 · S/N 340A0651 N55RBGots To Go LLC · Wilmington, DEBuilt 1975 · S/N 340A0015 N5655CRegistration Pending · Westford, MARegistration pendingBuilt 1980 · S/N 340A0969 N568TWWestray James H · Gainesville, GABuilt 1981 · S/N 340A1252 N56MAMinuteman Aviation Inc · Missoula, MTBuilt 1976 · S/N 340A0067 N56MELuttrell Jabe · Key West, FLBuilt 1977 · S/N 340A0316 N5751CRemy H Blanchaert Jr Dds Md Pa · Wichita, KSS/N 340A0974 N5757CRoberts Justin · Livingston, MTBuilt 1980 · S/N 340A0975 N5868CShimomura & Co Cpas Pc · New York, NYBuilt 1980 · S/N 340A0977 N58BJJmp Aviation Corp · Dover, DES/N 340A0723 N594BVJmak Corp · Seymour, TNBuilt 1978 · S/N 340A0440 N5CGSamair LLC · Blackshear, GABuilt 1979 · S/N 340A0751 N5HEFinancial Solution Services · Leesburg, FLS/N 340A0485 N60DMDatom Inc · Culver City, CABuilt 1979 · S/N 340A0711 N60EDawson Aircraft Inc · Clinton, ARBuilt 1979 · S/N 340A0663 N60PPJaams LLC · Shafter, CABuilt 1976 · S/N 340A0073 N60WHSan Clemente David Paul · Edgewater, FLBuilt 1976 · S/N 340A0083 N612JRQ & A Company LLC · Newport, RIBuilt 1980 · S/N 340A0927 N615PCBurning Blue LLC · Greenwood, MSBuilt 1978 · S/N 340A0615 N615PJEngelstad Dana P · Midland, TXFirst renewal noticeBuilt 1977 · S/N 340A-0260 N615SALordemann Holdings LLC · Kalispell, MTBuilt 1978 · S/N 340A0427 N618MROshaughnessy Stephen M · Littleton, COBuilt 1979 · S/N 340A0653 N61DDKissner Mark E · Frederick, MDS/N 340A1037 N6219CAbbott Todd Christopher · Houston, TXBuilt 1977 · S/N 340A0424 N6221CSahuaro Enterprises Inc · Moreno Valley, CAS/N 340A0426 N6225XN6225x LLC · Henderson, TNBuilt 1979 · S/N 340A0688 N6228XMad Doog Aviation LLC · Kalispell, MTBuilt 1977 · S/N 340A0431 N6240XCoal Black Cattle Co LLC · Roundup, MTBuilt 1977 · S/N 340A0437 N6258NTango Victor Aviation LLC · Kingsburg, CABuilt 1978 · S/N 340A0449 N6269NJuliet Tango Capital LLC · Saginaw, MIBuilt 1978 · S/N 340A0454 N626HMRb Aviation LLC · Tyler, TXBuilt 1981 · S/N 340A1280 N6276XWj Bolton Farms LLC · Mark Tree, ARBuilt 1978 · S/N 340A0460 N6290NShrauner Reid · Elkhart, KSBuilt 1978 · S/N 340A0464 N6292NAvjets LLC · Miami, FLFirst renewal noticeBuilt 1978 · S/N 340A0465 N6297XMike Sierra LLC · Brookings, SDS/N 340A0468 N6301XRonald A Peterson Inc DBA · Orlando, FLBuilt 1978 · S/N 340A0472

Back to Cessna 340A