Skip to content

Registered aircraft · 7,853

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.

N1776NStars And Stripes 1 Inc · Provo, UTBuilt 2017 · S/N 1361 N1776YSchwenker Kathleen M · Monclova, OHS/N 190 N177HBBarlett Sandra · Mentor, OHBuilt 2004 · S/N 002 N177HHPortland Rose Balloons LLC · Wilsonville, ORS/N 56/27 N177RFJones Gary R · Albany, NYBuilt 1972 · S/N 272 N177SSKrautter David L · Long Beach, CABuilt 1993 · S/N 6306 N1783Fly Lta LLC · Swisher, IABuilt 2022 · S/N 001 N1783FMoore Gary K · Lake Havasu City, AZBuilt 2023 · S/N LP2023-01 N1783KBack Country Ballooning LLC · Tres Piedras, NMBuilt 2024 · S/N 2303 N1783PRobinson David G · Half Moon Bay, CABuilt 2013 · S/N 004 N1783SStefan Karl · Austin, TXBuilt 2021 · S/N H006 N1783UAustin Aeronauts LLC · Hutto, TXBuilt 2002 · S/N 130/32 N1783YWagoner Benjamin A · Bristol, CTBuilt 2013 · S/N 5549 N17867Aero Club Albatross · Blairstown, NJBuilt 1973 · S/N 280 N17868Civil Air Patrol · Maxwell Afb, ALBuilt 1972 · S/N 246 N17873Peterson Adam · Bakersfield, CAS/N 243 N17874Aerodrome Services LLC · Maple Park, ILS/N 244 N17883Stewarts Aircraft Service Inc · Waynesville, OHBuilt 1972 · S/N 253 N17888Registration Pending · Tehachapi, CARegistration pendingBuilt 1972 · S/N 258 N17893Caprock Soaring Association · Lubbock, TXBuilt 1973 · S/N 273 N178BHHirashima Benjamin J · S San Fran, CABuilt 2024 · S/N 3.MD209 N178HPSekban Ali M · Honolulu, HIS/N 18-123 N178KLohre Charles R · Cincinnati, OHBuilt 1970 · S/N 15062 N178RFGroup I-34 LLC · Wauwatosa, WIBuilt 1970 · S/N 34 N17901Wisconsin Soaring Society Inc · Delafield, WIBuilt 1973 · S/N 291 N17902Honolulu Soaring Inc · Waipahu, HIBuilt 1973 · S/N 292 N17903Harris Hill Soaring Corp · Horseheads, NYBuilt 1973 · S/N 283 N17905Johnson Gustar M · Newton, NJBuilt 1972 · S/N 528 N17907Texas Soaring Association Inc · Midlothian, TXBuilt 1972 · S/N 527 N17908Soaring Society Of Dayton · Waynesville, OHBuilt 1973 · S/N 548 N17909K&L Soaring LLC · Cayuta, NYBuilt 1972 · S/N 529 N1791Leonard Steven E · Wichita, KSBuilt 1970 · S/N 74 N17911Simien Charles L · El Paso, TXS/N 541 N17912Kinder Rebecca L · Centennial, COBuilt 1972 · S/N 542 N17914Toews Donald W · Waipahu, HIBuilt 1973 · S/N 290 N17921Cumberland Soaring Group Inc · Wiley Ford, WVBuilt 1973 · S/N 81 N17923Blake Diane C · Orlando, FLBuilt 1972 · S/N 533 N17924Valley Soaring Club Inc · Middletown, NYBuilt 1972 · S/N 534 N17925Central California Soaring Associates Inc · Avenal, CABuilt 1972 · S/N 535 N17933Jersey Ridge Soaring LLC · Blairstown, NJBuilt 1973 · S/N 563 N17936Aliante LLC · Longmont, COBuilt 1973 · S/N 566 N17937Moos Milton H Trustee · Westerville, OHBuilt 1973 · S/N 567 N17938Silvercreek Glider Club · New Douglas, ILBuilt 1974 · S/N 588 N17940Antelope Valley Soaring Club · Llano, CABuilt 1972 · S/N 540 N17943Agnew Alfred P · Palm Beach Gardens, FLS/N 543 N17944Central Ohio Soaring Association Inc · Marion, OHBuilt 1972 · S/N 544 N17945Ward Timothy J · Mira Loma, CABuilt 1972 · S/N 545 N17947Kc Eagles Soaring Club · Gardner, KSBuilt 1973 · S/N 547 N17948Pfisters Flying Wahine LLC · Waialua, HIBuilt 1973 · S/N 78 N17949Webster Marc W · Glendale, CABuilt 1973 · S/N 549