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.

N65824Barrett Jane T · Tehachapi, CABuilt 1973 · S/N 304 N65825Nevada Soaring Association Inc · Reno, NVBuilt 1973 · S/N 305 N65828Wurtsboro Airpark LLC · Wurtsboro, NYS/N 325 N65829Caprock Soaring Association · Lubbock, TXBuilt 1974 · S/N 326 N65833Harris Hill Soaring Corp · Horseheads, NYBuilt 1974 · S/N 313 N65834Robertson Boyd W · Brandon, MSBuilt 1974 · S/N 314 N65839Harris Hill Soaring Corp · Horseheads, NYBuilt 1974 · S/N 329 N65840Black Forest Soaring Society · Monument, COBuilt 1974 · S/N 330 N65843Delash John M · Williamson, GABuilt 1974 · S/N 333 N65846Civil Air Patrol Inc · Montgomery, ALBuilt 1974 · S/N 336 N65848North Carolina Soaring Association · Zebulon, NCS/N 341 N65849Louisville Soaring Club Inc · Lexington, KYBuilt 1974 · S/N 339 N6584CBelk William E · Labelle, FLBuilt 1988 · S/N RX7-3109 N65850Gerred Michael S · Bel Air, MDBuilt 1988 · S/N S66A-3023 N65852Peterson Adam · Bakersfield, CAS/N 342 N65854Registration Pending · Spokane, WARegistration pendingBuilt 1974 · S/N 344 N65859Hobbs Soaring Society Inc · Hobbs, NMBuilt 1974 · S/N 347 N65865Irwin Luther J · Sahuarita, AZBuilt 1974 · S/N 350 N65867Soaring Tigers Inc · Princeton, NJBuilt 1974 · S/N 351 N65868Gabriel Jason B · Colorado Springs, COBuilt 2005 · S/N 1043 N65879Oklahoma Soaring Association · Mustang, OKFirst renewal noticeBuilt 1974 · S/N 352 N65882Hall Christopher G · Indianapolis, INBuilt 1974 · S/N 2 N658CRArizona Balloons Inc · Phoenix, AZBuilt 2022 · S/N 6951 N658KAKnerr Joshua D · Tehachapi, CAS/N 8497 N65911Brown Leonard W · Mims, FLBuilt 1974 · S/N 611 N65917Cumberland Soaring Group Inc · Wiley Ford, WVBuilt 1974 · S/N 87 N65918Long Island Soaring Association · Shirley, NYBuilt 1974 · S/N 358 N65924Imlay Scott T · Snohomish, WABuilt 1974 · S/N 594 N65929Conklin Kevin M · Washingtonville, NYBuilt 1973 · S/N 569 N65933Sutherland Charles T Jr · Stoneville, NCBuilt 1973 · S/N 573 N65934Albuquerque Soaring Club · Albuquerque, NMBuilt 1973 · S/N 574 N65935Moos Milton H Trustee · Westerville, OHBuilt 1973 · S/N 575 N65941Fun Country Soaring Inc · Avon Lake, OHBuilt 1974 · S/N 581 N65942Thermator Soaring Association LLC · Wilmington, DES/N 582 N65947Mohawk Soaring Club Inc · Hoosick Falls, NYBuilt 1974 · S/N 587 N65948New England Soaring Association · North Springfield, VTBuilt 1974 · S/N 578 N65950Frick Patrick D · Fort Myers, FLBuilt 1974 · S/N 580 N65964Bermuda High Soaring School Inc · Lancaster, SCBuilt 1974 · S/N 604 N65967Hamilton Soaring Club · Hamilton, TXBuilt 1974 · S/N 607 N65969Jousma Irwin J · Jenison, MIBuilt 1974 · S/N 609 N65972Sale Reported · Yucaipa, CASale reportedBuilt 1974 · S/N 591 N65973Pacific Rim Adventures Inc · Los Olivos, CABuilt 1974 · S/N 83 N65974Independence Glider Club · Independence, ORBuilt 1974 · S/N 354 N65975Abrantes George F · Morristown, NJBuilt 1974 · S/N 605 N65976Jersey Ridge Soaring LLC · Blairstown, NJBuilt 1974 · S/N 356 N65ABGallant Michael T · Columbus, INBuilt 1983 · S/N S55A-1023 N65DCLester David J · Centennial, COBuilt 1977 · S/N 794 N65JJJackson James A · Houston, TXBuilt 1993 · S/N 472 N65LEZawodny Jeremy D · Groveland, CABuilt 1982 · S/N 108 N65LSPruitt Paul N · Santa Barbara, CABuilt 1983 · S/N 4353