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.

N45013Big Dog Ballooning LLC · Albuquerque, NMBuilt 2004 · S/N 6358 N4501FKnuth Paul A · Davenport, FLBuilt 2002 · S/N 6311 N4501WWoodward Jay DBA · Carnation, WABuilt 2003 · S/N 6339 N4501YKiehle Erik A · Meridian, MSBuilt 1993 · S/N 5845 N4502AFitzgerald William J · Lubbock, TXS/N 166 N4502JScott Jody K · Mason, MIBuilt 2002 · S/N 6315 N4502QCoconcelli Luke S · Albuquerque, NMBuilt 1993 · S/N 5885 N4502VCarlton Dean E · Danville, ILFirst renewal noticeBuilt 2003 · S/N 6331 N4502WCoan Larry K · New Hudson, MIBuilt 2004 · S/N 6356 N45030Zing Aerosports LLC · Peoria, AZBuilt 2003 · S/N 6334 N4503PRinehart James E · Xenia, OHBuilt 2002 · S/N 6320 N4503XHaynes Anthony · Houston, TXBuilt 2001 · S/N 6288 N45044Dropps Daniel E · Cottonwood, AZS/N 162 N4504JHigh Flight Inc · Grass Lake, MIBuilt 2003 · S/N 6333 N4504RSerge Brian K · Indianopolis, INS/N 6305 N4504WCarrington Dean L · Peterson, IABuilt 1988 · S/N 151 N45054Browning Derek A · Louisville, KYBuilt 2003 · S/N 6337 N45059Whittles Lorne J · Boise, IDBuilt 1993 · S/N 5917 N4505BP Marks Plus Inc · Cornville, AZBuilt 2003 · S/N 6317 N4505FSeeley Dwayne · Dover, DEBuilt 1976 · S/N 28-7715042 N4505NPallister Joshua David · Helena, MTBuilt 2003 · S/N 6340 N45061Fritton Robert A Jr · Gasport, NYBuilt 2003 · S/N 6364 N45062Paisley John Jr · Burlington, NCBuilt 2004 · S/N 6372 N4506DJones Derrick J · Grandville, MIBuilt 2002 · S/N 6316 N4507WRenaissance Balloons LLC · Hartland, MIBuilt 2004 · S/N 6362 N4508BKim Frank · Rio Rancho, NMBuilt 2003 · S/N 6327 N4508EKing Scott M · Midland, MIS/N 6330 N4508LSale Reported · HamiltonSale reportedS/N 6366 N45092Always Time To Fly LLC · Glendale, AZBuilt 2005 · S/N 6388 N45096Gibson Westly M · Longview, TXBuilt 2005 · S/N 6389 N4509AAir Hound Adventures LLC · Davenport, FLS/N 194 N4509LKrause Colton · Pride, LAS/N 6352 N4509NQuintana Jacob E · Albuquerque, NMBuilt 2004 · S/N 6383 N4509UWilson Michael · Hickory Creek, TXBuilt 2004 · S/N 6381 N450BHDougherty Donald A · Colorado Springs, COS/N 001 N450LBSkycab Balloon Promotions LLC · Louisville, KYBuilt 2007 · S/N 5367 N450TEJohnson Amanda L · Prosser, WAS/N 5361 N45109Keller Clifford G · Santa Cruz, NMBuilt 1994 · S/N 5882 N4510BQuartuccio David M · Ballwin, MOBuilt 2003 · S/N 6349 N4510KMcmanus William E Jr · Jonesborough, TNFirst renewal noticeBuilt 1992 · S/N 186 N4510LAuras Adventures LLC · Oak Point, TXBuilt 2002 · S/N 6321 N4510NFirst & Finest A Non Profit Corp · Deptford, NJBuilt 2005 · S/N 6393 N4510WJackson Zackery · Fishers, INBuilt 2005 · S/N 6390 N4511KMaddox Jeffrey A · Toney, ALBuilt 2002 · S/N 6324 N45124Vaughn Charles M DBA · Jacksonville, FLBuilt 1991 · S/N 182 N4512WPiper John T · Pearl River, NYBuilt 2019 · S/N 1508 N4514LBristol David W · Sautee, GABuilt 1990 · S/N 163 N45177Bristol David W · Sautee, GABuilt 1992 · S/N 197 N4519URadowski Johnathan P · Phoenix, AZBuilt 1992 · S/N 184 N451BSJbskinner LLC · San Angelo, TXBuilt 2024 · S/N 60/07