Skip to content

Registered aircraft · 8,920

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:85-02-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-02-05-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:85-02-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-02-05-R1')
  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, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:85-02-05-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-02-05-R1')
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.

N6823PKoopmans Caleb · Bridgewater, SDBuilt 1960 · S/N 24-1956 N6823YWingsleasing LLC · Wichita, KSBuilt 1969 · S/N 27-4163 N6824PAtlas Equipment LLC · Casper, WYBuilt 1960 · S/N 24-1957 N6825BAlborn Wyatt A · Homer, AKBuilt 1956 · S/N 22-4121 N6825YDenton J Frederick · Hutchinson Island, FLS/N 27-4165 N6828BVantreese Jason B · Quanah, TXS/N 22-4125 N6829LEntropic Synergies LLC · Visalia, CAS/N 25-4960 N682ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEBuilt 2010 · S/N 4496285 N682DCSteele Aviation Inc · Walnut Cove, NCBuilt 1961 · S/N 22-8660 N682FGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 1969 · S/N 30-1955 N6830PGregory M Gabriela · Las Vegas, NVBuilt 1960 · S/N 24-1963 N6833BBlatchford Devin M · Arkansas City, KSBuilt 1956 · S/N 22-4131 N6833PHolmes Darrell · Chino Hills, CABuilt 1960 · S/N 24-1966 N6835PMarvin Shawn · Tomahawk, WIS/N 24-1968 N6836BHowes Christopher T · Allardt, TNBuilt 1956 · S/N 22-4134 N6836YOld School Aircraft LLC · Jackson, TNBuilt 1969 · S/N 27-4176 N6838BMize Donnie Glenn · Pearland, TXBuilt 1956 · S/N 22-4136 N6838PHartley Victor A III · Woodbine, NJS/N 24-1971 N6839PFriesen Brad A · Plains, TXBuilt 1960 · S/N 24-1972 N683ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEBuilt 2010 · S/N 4496286 N6843YBarlam Theodore P · Poway, CABuilt 1969 · S/N 27-4187 N6844ZAntelope Valley Soaring Club · Llano, CABuilt 1963 · S/N 25-2516 N6845BShrode Rafe C · Jewett, TXS/N 22-4144 N6847BOtt Grosvenor LLC · Dillingham, AKBuilt 1956 · S/N 22-4146 N6848BPainter William L · Salem, VAS/N 22-4147 N6849BWeeks Vaughan B · Racine, WIS/N 22-4148 N6849PSvenningsen Joshua J · Menomonie, WIBuilt 1960 · S/N 24-1983 N684ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEBuilt 2010 · S/N 4496287 N6852BTaylor David L · Mexico, MOBuilt 1956 · S/N 22-4151 N6852PHauf Michael L · Minot, NDBuilt 1960 · S/N 24-1986 N6853PNolan Donald E · Oro Valley, AZBuilt 1960 · S/N 24-1987 N6853ZChristian Aviation LLC · Pearland, TXBuilt 1963 · S/N 25-2534 N6854YChagres Flight Training LLC · Albuquerque, NMBuilt 1969 · S/N 27-4198 N6855BSmith Cody P · Fairbanks, AKS/N 22-4153 N6856BEberly Joshua D · Middletown, OHBuilt 1956 · S/N 22-4156 N6856PPerkey Gilbert J · Eagle Rock, VABuilt 1960 · S/N 24-1992 N6856YAviation Data LLC · Carson City, NVBuilt 1969 · S/N 27-4200 N6857PHuntsman John E · West Linn, ORBuilt 1960 · S/N 24-1993 N6857YGraves Jessica M · Anthony, KSBuilt 1969 · S/N 27-4202 N6857ZBarrett Jane T · Tehachapi, CABuilt 1963 · S/N 25-2538 N6859ZEd Air Inc · Oaktown, INBuilt 1963 · S/N 25-2540 N685ATTexas Flight Training Aircraft 8 LLC · Wilmington, DES/N 4496288 N685MDAbacus Automation Inc · Bennington, VTBuilt 1969 · S/N 27-4295 N6860PRegistered aircraftBuilt 1960 · S/N 24-1996 N6862PWeber Phillip A · Stroudsburg, PABuilt 1960 · S/N 24-1998 N6862ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1963 · S/N 25-2548 N6863YDempsey Donald B · Deland, FLBuilt 1969 · S/N 27-4208 N6865AAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496256 N6865BEllis Ray Lynn · Lakeside, CABuilt 1956 · S/N 22-4165 N6865YDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1969 · S/N 27-4210

Back to AD 85-02-05 R1