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.

N8521JHanbicki Deiter T · Albuquerque, NMBuilt 2006 · S/N 32951 N852BGField Drew · Dallas, TXBuilt 1985 · S/N 34014-K-247 N8530PBroemmer Olivia L · Albuquerque, NMS/N 260 N853BGSouthern California Soaring Academy Inc · Valencia, CAS/N 5640 CB N85415Sky High Holdings LLC · Atlanta, GABuilt 2016 · S/N 5605 N854ALeonard Steven E · Wichita, KSBuilt 1973 · S/N 5 N8559Navarette Brian K · Toledo, OHS/N 70 N855LBAerostation Limited Inc · Franklin, TNBuilt 2002 · S/N 5207 N856BGTampa Bay Soaring Society Inc · Zephyrhills, FLS/N 34020-K-252 N857MYTrappe Jonathan R · Austin, TXBuilt 2020 · S/N 1675 N857ZCook Charles T · Angier, NCBuilt 1962 · S/N 153 N858Davenport John P · Redmond, WAS/N 15231 N858EWidner Jack A · Stanley, NCBuilt 1975 · S/N 20051 N8595Bitikofer Dawid K · Kansas City, KSBuilt 1970 · S/N 33 N859GSBoone Jerry W · Hutchinson, KSBuilt 1978 · S/N 13 N85AAFallah Albert M · Spring, TXBuilt 1978 · S/N 3277 N85CBBuzzards Glory Balloon Co LLC · Cedar Rapids, IABuilt 1976 · S/N 302 N85HBMarkowitz David B · Maryland, NYBuilt 2022 · S/N CAT 1 N85UMSpeicher Kerry J · Longview, TXBuilt 2022 · S/N 56/70 N8601RFuller Paul H · Powell, OHBuilt 1961 · S/N 105 N8602RNorth Penn Squadron Soaring Assoc · Hatfield, PAS/N 118 N8603RAlpha Whiskey LLC · Everett, WABuilt 1961 · S/N 130 N8612RIndependence Aviation LLC · Independence, ORBuilt 1961 · S/N 139 N8613RClipp John W · Fayetteville, GAS/N 118 N8615RSexton James R · Kinards, SCBuilt 1961 · S/N 142 N8616RWhiting Stephen D · Poway, CABuilt 1961 · S/N 144 N861LBWalsh Daniel P · Redlands, CAS/N 5430 N8621RKo Nam H · Kaneohe, HIBuilt 1961 · S/N 154 N8622RBowlsbey Bryan · Mclean, VABuilt 1961 · S/N 58 N8623RSale Reported · Tyler, TXSale reported, pending cancellationBuilt 1962 · S/N 152 N8627REkman Kenneth P · Palm Coast, FLBuilt 1961 · S/N 160 N8628RGalbraith Judith · Waynesburg, PABuilt 1962 · S/N 157 N8629RMcdonald Frank G III · Acworth, GABuilt 1962 · S/N 142 N862ZBBarsketis Coby Aj · Napa, CABuilt 2019 · S/N 001 N8631RYakubek Christopher P · Oakland, CABuilt 1962 · S/N 60 N8634RTreasure Coast Soaring Club Inc · Vero Beach, FLS/N 851 N8636RAbel William F · Billings, MTBuilt 1962 · S/N 180 N8637RAir Biscuit LLC · Williamson, GABuilt 1962 · S/N 181 N8638RSchweizer Kyle B · Horseheads, NYS/N 61 N8639RLakeland Aero Club Inc · Lakeland, FLBuilt 1963 · S/N 173 N863AFLufthansa Aviation Training USA Inc · Goodyear, AZBuilt 2001 · S/N 85003 N8641RWilkinson Ephriam B · Eads, TNBuilt 1962 · S/N 184 N8642Brandywine Soaring Assoc · Hockessin, DEBuilt 1975 · S/N 642 N8642RPalmer Mark F · Greenwood Village, COS/N 182 N8644RKerr Joshua D · Shafter, CAS/N 185 N8645RKramer Dean E · Bernville, PABuilt 1962 · S/N 147 N8646RWhitman David L Jr · Centreville, VABuilt 1962 · S/N 148 N8647RLutes Ralph E · Shipshewana, INBuilt 1963 · S/N 149 N8649RPickens Edward Cleveland · Raleigh, NCBuilt 1962 · S/N 186 N8650KPierce Jeffrey S · Batavia, OHS/N 108-1650