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.

N76TSStrand Thomas L · Lake Ariel, PABuilt 2011 · S/N 5478 N76WMIglesias Carolina · Waller, TXBuilt 1976 · S/N 20139C N76YAFranks Megan E · Temecula, CABuilt 2016 · S/N 300/76 N7700RColler Randy L DBA · Jackson, MIBuilt 2009 · S/N 6559 N7701SCentral Ohio Soaring Assoc Inc · Marion, OHBuilt 1968 · S/N 121 N7706SAbove And Beyond Hawaii LLC · Waimanalo, HIBuilt 1968 · S/N 64 N7707SHanley Stuart Anthony · Hollywood, FLS/N 407 N7707ZEgerton James A · Statesville, NCBuilt 2015 · S/N 447 N770DYBrown Thomas J · Plainwell, MIBuilt 2013 · S/N 986 N770SGHutchinson Terry S · Albuquerque, NMBuilt 2008 · S/N 5406 N770UMFlatt Herby A · Henryetta, OKBuilt 2015 · S/N 77/393 N7710Carmel Paul A · Santa Clara, CABuilt 1966 · S/N 819 N7710SLloyd Clee E · Canby, ORS/N 411 N7712SLas Vegas Valley Soaring Assoc · Jean, NVBuilt 1968 · S/N 412 N7713SShenandoah Valley Soaring Inc · Nellysford, VABuilt 1968 · S/N 413 N7714Kolberg Rocky S · Kelso, WABuilt 1967 · S/N 4131 N7714SSharp John W · Opelika, ALBuilt 1968 · S/N 414 N7716SDittman William H · Palmetto, FLBuilt 1968 · S/N 416 N7717SMcgovern Glenn C · Metairie, LABuilt 1968 · S/N 417 N771DBKaplan Asher H · Tucson, AZBuilt 1985 · S/N 75 N771HBrown Stephen K · Meredith, NHBuilt 1971 · S/N 75 N771RMMcgovern Glenn C · Metairie, LABuilt 1997 · S/N 240CS N771SYDaye Jeffrey E · Salisbury, NCBuilt 1959 · S/N 39 N771WHJ O B B Investments Inc · San Angelo, TXBuilt 2014 · S/N 5569 N771ZMichael Matthew C · Ames, IAS/N 859 N7721SFueston Vernon A · Montague, CABuilt 1969 · S/N 399 N7724SHull Mahlon B · Sedro Woolley, WAS/N 424 N7725SElliott Donald E III · Lexington, SCBuilt 1968 · S/N 425 N7728SAuburg George Randell · Midland, TXBuilt 1968 · S/N 428 N7729Indrebo Rick J · Livermore, CABuilt 2006 · S/N 29008 N772ABAer Blarney Balloons LLC · Bethlehem, CTBuilt 2025 · S/N 14/01 N772RSClark Aviation Adventures LLC · Cottonwood Heights, UTBuilt 2018 · S/N 1410 N772TCWooge G Scott · Swisher, IABuilt 1993 · S/N 2389 N7730SFairbairn Jay A · Fort Worth, TXBuilt 1968 · S/N 430 N7732SKendall Flying Services LLC · Miami, FLBuilt 1968 · S/N 432 N7733SOrr Roger E · Prineville, ORBuilt 1968 · S/N 433 N7734SSuperior Soaring LLC · Scottsdale, AZBuilt 1968 · S/N 434 N7736SHeaberlin Henry L · Corbin, KYBuilt 1968 · S/N 436 N7738SNorth Florida Soaring Society Inc · Jacksonville, FLBuilt 1969 · S/N 438 N7739SMemphis Soaring Society Inc · Memphis, TNBuilt 1969 · S/N 439 N773LBObrien Robert P · Waupaca, WIBuilt 2004 · S/N 5273 N773WHPaddie Joe H Jr · Longview, TXBuilt 2011 · S/N 5497 N7740SCampos Carlos A Puig · Miami, FLS/N 440 N7741SScrap Metal LLC · Mountainside, NJBuilt 1969 · S/N 441 N7742SFueston Vernon A · Montague, CABuilt 1969 · S/N 442 N7743SDorman Richard E · Mesa, WABuilt 1969 · S/N 443 N7744PBoulet Mark D · Billings, MTBuilt 2021 · S/N 1853 N7745Wabash Valley Soaring Assn Inc · Lawrenceville, ILBuilt 1968 · S/N 13084 N7745STreasure Coast Soaring Club · Port Saint Lucie, FLBuilt 1969 · S/N 445 N7746SHorizon Aircraft Sales Ltd · Sayville, NYBuilt 1969 · S/N 69