Skip to content

Registered aircraft · 7,858

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.

N3821ADaniel Gordon W · Dillsburg, PABuilt 1958 · S/N 66 N3822AFinger Lakes Soaring Club Inc · Dansville, NYBuilt 1958 · S/N 78 N3824AAgostini Joseph L · Broomall, PABuilt 1961 · S/N 82 N3825ACook Charles N · Fort Worth, TXS/N 80 N3827AMidwestern Soaring Association · Peculiar, MOBuilt 1959 · S/N 89 N382RGTucson Soaring Club Inc · Phoenix, AZS/N 1706001 N382WJones J Philip Jr · Truro, MABuilt 1974 · S/N 15 N3830AWilliams Catherine A · Minden, NVBuilt 1959 · S/N 97 N3834ACapitini James J · Oakland Gardens, NYBuilt 1960 · S/N 99 N3837ATsidjs LLC · Lehighton, PABuilt 1961 · S/N 67 N3837MCross Country Soaring Inc · Lonsdale, MNBuilt 1983 · S/N 3764 N3838AStogner Michael E · Cubero, NMBuilt 1960 · S/N 105 N3839AWalker William Hamilton · Bainbridge, GABuilt 1961 · S/N 107 N383BATampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 2000 · S/N 008714 N383NRice Deborah A · Houston, TXBuilt 2004 · S/N 006-31 N3841Williams Jon M · Oviedo, FLBuilt 1968 · S/N 29 N3846AFullerton Alan D · La Crosse, WIS/N 43 N3848AAlbertson James M · Westville, FLFirst renewal noticeS/N 65 N384CBLoeffler Steven R · Albuquerque, NMBuilt 1983 · S/N 684 N384KGBrossett Gary M · Columbus, GABuilt 2021 · S/N 496 N3851ABreidenthal Robert E · Seattle, WAS/N 7 N3852AJohnson Gustav M · Newton, NJBuilt 1953 · S/N 8 N3853AMellies Thomas · Chestertown, MDBuilt 1956 · S/N 12 N3854AEsser Paul H · Fairfield, CTBuilt 1955 · S/N 15 N3855ATomco Stores Ltd · Ruidoso, NMBuilt 1955 · S/N 19 N3856AHaskell Charles T · Atlanta, GABuilt 1956 · S/N 21 N3858ABryan Danny J · Hobbs, NMBuilt 1955 · S/N 24 N3859AKellum Mark J · Belden, MSBuilt 1956 · S/N 28 N3860AFreeland Chris G · Brownwood, TXS/N 17 N3861AMahony John · Ballston Spa, NYS/N 10 N3862AKendall Flying Services LLC · Miami, FLBuilt 1957 · S/N 11 N3863ABradley David F · Lehighton, PABuilt 1955 · S/N 20 N3864ABrown Peter D · Anchorage, AKBuilt 1959 · S/N 44 N3865AKecskes Stephen A · Austin, TXBuilt 1958 · S/N 26 N386UZPortland Rose Balloons LLC · Wilsonville, ORBuilt 2004 · S/N CAH-20090013 N3870ANorth Carolina Soaring Association · Zebulon, NCS/N 5 N3871AHilty Grant · Prescott Valley, AZS/N 6 N3872Wiley Earl S · Raleigh, NCBuilt 1971 · S/N 218 N3873AHarvey Todd E · Erie, COBuilt 1956 · S/N 16 N3874AMussman Craig · Grant Park, ILBuilt 1956 · S/N 35 N3875ACirri Joseph A · Deming, NMS/N 37 N387BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 2001 · S/N 018802 N3882ABowlsbey Bryan W · Mclean, VABuilt 1956 · S/N 44 N3884AVan Wormer Willard D · Leavenworth, KSBuilt 1958 · S/N 45 N3885ADecker Lane M · San Diego, CABuilt 1970 · S/N 50 N3886APalmquist Neal D · Homer, LABuilt 1956 · S/N 53 N3888AHoover Michael B · Ridgeland, WIBuilt 1951 · S/N 51 N3890ASullivan Terrence Michael II · San Marcos, TXBuilt 1957 · S/N 51 N3893AWebb James T · Plantersville, MSS/N 57 N3894AMartin Ronald P · Tehachapi, CAS/N 59