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.

N677RARa Aviation LLC · Omaha, NEBuilt 1968 · S/N 24-4764 N6780PMichigan Sky LLC · Lowell, MIBuilt 1960 · S/N 24-1911 N6781PDemontigny Tyler R · Redding, CABuilt 1960 · S/N 24-1912 N6782ZWillamette Valley Soaring Club · Beaverton, ORBuilt 1963 · S/N 25-2418 N6783PSmith Donald W · Fountainville, PABuilt 1960 · S/N 24-1914 N6786YMuhlenkort Mary Anna · Beresford, SDBuilt 1968 · S/N 27-4122 N6787YCoachron Investments · Grosse Ile, MIBuilt 1969 · S/N 27-4124 N6788PEast Cascades Aviation LLC · Powell Butte, ORBuilt 1960 · S/N 24-1792 N6789PDawn Aviation LLC · Pierce City, MOBuilt 1960 · S/N 24-1921 N6791ZAir Care Inc · Lamar, COBuilt 1963 · S/N 25-2435 N6792ZMid Continent Aircraft Corp · Hayti, MOBuilt 1963 · S/N 25-2436 N6793PMitchell Flying Service LLC · Cushing, OKBuilt 1960 · S/N 24-1926 N6793YPiper Aircraft Inc · Vero Beach, FLBuilt 1969 · S/N 27-4131 N6793ZJnc Aviation LLC · Saint Louis, MOBuilt 1963 · S/N 25-2438 N6794PGomez Oscar · El Mirage, AZBuilt 1960 · S/N 24-1927 N6794ZKnutson Wayne R · Tioga, NDBuilt 1963 · S/N 25-2439 N6797PBradley Jim · Waldorf, MDBuilt 1960 · S/N 24-1930 N6799PThomas Nicholas O · Cave Springs, ARS/N 24-1932 N679AFord Darryl E · Aurora, COBuilt 1951 · S/N 22-81 N67TXInternational Air Services Inc Trustee · Carson City, NVBuilt 1966 · S/N 30-1133 N6800BHall John L · Port Angeles, WABuilt 1956 · S/N 22-4095 N6800PBrown Farms Inc · Central City, NEBuilt 1960 · S/N 24-1933 N6802BHales Evan C · Haines, AKBuilt 1956 · S/N 22-4097 N6802PCappiello Robert · Canyon Country, CAS/N 24-1935 N6803PSchroer Donald D · Bridgeport, TXBuilt 1960 · S/N 24-1936 N6803ZWagner Nathan D · Dane, WIBuilt 1963 · S/N 25-2452 N6804BJanusz Stephen F · Westerville, OHBuilt 1956 · S/N 22-4099 N6805P250 Aero LLC · Wells, MIBuilt 1960 · S/N 24-1938 N6806BGalloway Michael C · Prim, ARBuilt 1956 · S/N 22-4101 N6808BWroe Daniel C · Denton, MDBuilt 1956 · S/N 22-4102 N6809PMerino Cesar · Washington, DCS/N 24-1942 N6809YPiper Aircraft Inc · Vero Beach, FLBuilt 1969 · S/N 27-4147 N680KTalos Aviation Group LLC · Blackstone, VABuilt 1968 · S/N 27-3892 N680NDMedary Aviation LLC · Brookings, SDBuilt 2015 · S/N 4496384 N680TCFlight Training Aircraft LLC · Wilmington, DES/N 44-7995063 N6810POlmedo Refugio J · Lancaster, CABuilt 1960 · S/N 24-1943 N6810YAtem LLC · Helena, ALBuilt 1969 · S/N 27-4148 N6810ZAlbuquerque Soaring Club Inc · Albuquerque, NMBuilt 1963 · S/N 25-2471 N6811Dinnerbell Farms LLC · Eden, WIBuilt 1957 · S/N 22-4783 N6814BMensing John P · Country Club Hills, ILBuilt 1956 · S/N 22-4109 N6814PFuller Michael David · Palmdale, CAFirst renewal noticeBuilt 1960 · S/N 24-1947 N6814YHartwig Acft Fuel Cell Repair Ltd · Hallock, MNBuilt 1969 · S/N 27-4153 N6815BCopper River Airmotive LLC · Copper Center, AKBuilt 1956 · S/N 22-4111 N6816AAtp Aircraft 8 LLC · Wilmington, DEBuilt 2008 · S/N 4496262 N6816PElliott Patrick K Sr · North Bend, ORBuilt 1960 · S/N 24-1949 N6817BHarvey Benjamin A · Mountain View, CABuilt 1956 · S/N 22-4113 N6817YInternational Air Services Inc Trustee · Carson City, NVS/N 27-4156 N6818AAtp Aircraft 8 LLC · Wilmington, DEBuilt 2008 · S/N 4496263 N6820BAnderas Per R · Green Bay, WIS/N 22-4116 N6821PComanche Logistics LLC · Lake City, FLBuilt 1960 · S/N 24-1954

Back to AD 85-02-05 R1