Skip to content

Registered aircraft · 7,860

Aircraft with this engine 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 engine_model_code IN ('00000')
  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 engine_model_code IN ('00000')
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.

N91812Siegfried Thelma J Trustee · Downers Grove, ILBuilt 1946 · S/N 24 N91815Manzo Christopher A · Gainesville, GABuilt 1946 · S/N 32 N91817Mcknight Thomas N · Fredericksburg, TXBuilt 1946 · S/N 39 N91818Clemens Russell E · El Cajon, CABuilt 1946 · S/N 38 N91825Keller Joel F · Lebanon, PABuilt 1946 · S/N 49 N91829Harrier Soaring Club Inc · Raleigh, NCBuilt 1956 · S/N 32 N91837Washington Buddy K · Ten Sleep, WYBuilt 1946 · S/N 11 N91840Byars Guy F · Goshen, OHS/N 1 N91841Schutze Richard P Trustee · Ojai, CABuilt 1946 · S/N 14 N91843Dexter Fred H · Live Oak, FLBuilt 1946 · S/N 16 N91847Derrickson Jack N · Waynesville, OHBuilt 1946 · S/N 22 N9184DLivadas Greg · Penfield, NYBuilt 1994 · S/N RX8-3196 N9184JStevens Patrick · Phoenix, AZS/N S50A-3005 N9184MMcvay Gilbert Lynn · Trenton, MOBuilt 1994 · S/N RX8-3197 N9184NBates Diane Executor · Fort Myers, FLBuilt 1994 · S/N RX7-3300 N91850Clayton Harry L · Wichita, KSBuilt 1946 · S/N 27A N91858Crank R Wayne Jr · Shreveport, LABuilt 1947 · S/N 29 N91861Short James B · Crown Point, INS/N 2 N91865K & L Soaring LLC · Cayuta, NYS/N 33 N9186GDennis Polen Aviation Educational Foundation · Granbury, TXBuilt 1995 · S/N 17.03.020 N91872Fueston Vernon A · Montague, CABuilt 1949 · S/N 7 N91873Grant James B · Fairview, ORS/N 8 N91875Snyder Jeffrey R · Mountainair, NMS/N 10 N91877Peterson Adam C · Bakersfield, CAS/N 12 N91878Bonser Thomas A · Cincinnati, OHBuilt 1950 · S/N 14 N91879Leonard Steven E · Wichita, KSBuilt 1950 · S/N 15 N91880Westcott Philip G · Elmira, NYBuilt 1952 · S/N 17 N91881Burns Robert A · Leavenworth, KSBuilt 1952 · S/N 18 N91882Lowry Wilson R · Leonardtown, MDBuilt 1952 · S/N 20 N91883Kramer Dean E · Bernville, PABuilt 1946 · S/N 44 N91885Lowry Wilson R · Leonardtown, MDBuilt 1949 · S/N 3 N91887Goodman Jonathan N · Williamsburg, MABuilt 1953 · S/N 27 N9188XGreater Houston Soaring Assoc · Needville, TXBuilt 1965 · S/N 6357 N91893Bikle Michael Trustee · Salinas, CABuilt 1955 · S/N 30 N91894Nixon H M · Wayne, NJBuilt 1954 · S/N 2 N91895Massey Air Museum Inc · Massey, MDFirst renewal noticeBuilt 1955 · S/N 39 N91896Lowry Wilson R · Leonardtown, MDBuilt 1955 · S/N 28 N91897Blue Falcon LLC · Charlottesville, VABuilt 1956 · S/N 34 N918LMMcdonald Louis N III · Bernville, PABuilt 2007 · S/N 29026 N918PLCheatham Paul F · La Verne, CABuilt 2019 · S/N 5703 N9190ZThayer Allen D · Albuquerque, NMBuilt 1960 · S/N 1 N9195Scheidt Carl M · Peachtree City, GABuilt 1969 · S/N 75 N9199Air & Field Equipment LLC · Moore, IDBuilt 1978 · S/N 20116 N919BRRogers Service Group Inc · Binghamton, NYBuilt 2007 · S/N 5384 N919DTBluegrass Balloons LLC · Louisville, KYBuilt 2006 · S/N 5332 N919KDJohnson Aaron R · Vershire, VTBuilt 2001 · S/N 5165 N919NDouglas Dutton · Lindsborg, KSBuilt 1971 · S/N 175 N919TWGriswold Scott · Selkirk, NYBuilt 2024 · S/N 2306 N91BGAndrews Kenneth S · Clinton Township, MIS/N 5529S N91JDWeindel Zachary P · East Greenwich, RIBuilt 1990 · S/N S55A-3057