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.

N267BATcoag1 LLC · Maple Park, ILBuilt 1993 · S/N 938025 N2681LOtero Charlie M · Corrales, NMS/N 386 N2682HDysinger Larry K · Chester, NYBuilt 1977 · S/N 92 N2689HSale Reported · Colorado Springs, COSale reported, pending cancellationBuilt 1978 · S/N 509 N268MPMarcus Hook Glider Works · Wilmington, DEBuilt 2007 · S/N 526 N2690HEastern Shore Helicopters Inc · Labelle, FLBuilt 1978 · S/N 510 N2692HPiercy Ronald S · Moses Lake, WABuilt 1978 · S/N 526 N2693HCirri Joseph A · Deming, NMBuilt 1977 · S/N 673 N269MMacskimming Mark · Harrisburg, PABuilt 2008 · S/N 6524 N26BSJenn-Air Hot Air Balloon Team LLC · Kalispell, MTBuilt 2025 · S/N 2546 N26HLEngel Carl J · Campbell, CAS/N 31 N26JKUsda Aphis Ws Atoc · Cedar City, UTBuilt 1967 · S/N 67-16681 N26KKPhilip Mark A · Leesburg, VABuilt 1984 · S/N 20649 N26LSGadomski David M · Albuquerque, NMBuilt 1980 · S/N 3447 N26NCNc Hot Air LLC · Shelby, NCBuilt 2026 · S/N 2608 N26QKBroker William · Wylie, TXBuilt 2026 · S/N B5-65-004 N26TEStandish Jason L · Brook, INBuilt 1971 · S/N 101 N26UMMars Leasing · Phoenix, AZBuilt 2023 · S/N 300/108 N26XCangahuala Laureano A · Claremont, CABuilt 1977 · S/N 3002 N26XTAerostatica Inc DBA · Ann Arbor, MIBuilt 2026 · S/N 7050 N2701ZLessard George · Redlands, CABuilt 1964 · S/N 222 N27035Blue Ridge Hot Air Balloons LLC · Front Royal, VAS/N 632 N2703ZFaultline Flyers · Leander, TXBuilt 1963 · S/N 235 N2705CMiller Bruce A · Plano, TXBuilt 1955 · S/N 591 N2705ZDunten Teri · Moses Lake, WAS/N 241 N2706HBeyer Ricky B · Lowville, NYBuilt 1976 · S/N 456 N2706ZHobbs Soaring Society Inc · Hobbs, NMBuilt 1964 · S/N 236 N27085Stefan Karl · Greer, SCS/N F8B-2121 N2708AAntique Preservation Assoc Greenfld · Greenfield, IABuilt 1956 · S/N 30A N2708ZSale Reported · Waynesville, OHSale reportedBuilt 1964 · S/N 242 N2709HMajor Travis S · Phoenix, AZBuilt 1978 · S/N 89 N270ASWeck Geoffrey E · Woodstock, ILS/N 27147 N270BAMudd Robert J · Moriarty, NMBuilt 1993 · S/N 938027 N270BBVesely Scott · Frisco, TXBuilt 2023 · S/N 005 N270SSMiller Benjamin J · Alliance, OHBuilt 2019 · S/N 100 N270VTKing Michael G · Sandia Park, NMBuilt 2023 · S/N 6971 N27105Payne Ralph J · Hastings, MIBuilt 1977 · S/N 780 N27109Hannigan Joyce J · Colorado Springs, COBuilt 1977 · S/N 773 N2710ZPalmquist Neal D · Homer, LABuilt 1966 · S/N 238 N2717ZWroe Daniel C · Denton, MDBuilt 1964 · S/N 170 N271BAGreater Houston Soaring Association · Needville, TXBuilt 1994 · S/N 948112 N271BLVinarub Marc R · Webster, FLBuilt 1972 · S/N 271 N271FMmmdam LLC · Midlothian, TXBuilt 1993 · S/N 24216 N271JHSchmidt Mark A · San Marino, CABuilt 2003 · S/N 27217 N271JSArmstrong Daniel J · Tehachapi, CABuilt 1996 · S/N 27035 N2720COchsner David W · Clinton Twp, MIBuilt 1957 · S/N 294 N2720ZLaitinen David P · Raleigh, NCBuilt 1964 · S/N 67 N2721HGreater Houston Soaring Association · Needville, TXBuilt 1977 · S/N 661 N2721ZMathison John M · Del Norte, COBuilt 1965 · S/N 243 N2722ZCahill Dennis M · Albuquerque, NMBuilt 1965 · S/N 244