Registered aircraft · 25,369

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N6086GAbovestandard LLC · Denison, TXBuilt 1979 · S/N 17273566 N6086SDos Lobos Aviation LLC · Yankton, SDBuilt 1980 · S/N R18201610 N6087QTyson Michael A · Cupertino, CABuilt 1965 · S/N 910 N6088HWright Duane · Sanford, FLS/N 15284129 N6088PSide Deck Event Management LLC · Lexington, SCBuilt 1978 · S/N P21000141 N6088QParker Justan · New Durham, NHBuilt 1965 · S/N 911 N6089KDelta State University · Cleveland, MSBuilt 1980 · S/N 17274166 N6089MAirplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1980 · S/N 15284617 N6089QMolnar Victor · Ballston Spa, NYBuilt 1965 · S/N 3259 N608DLByler Jason M · Middlefield, OHS/N 17274998 N608EAKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 15282193 N608FDMjd Yuma Enterprises LLC · Yuma, AZBuilt 1981 · S/N 21064261 N608FMSouth Bay International Flight Association Inc · Torrance, CABuilt 1978 · S/N 15282795 N6090VRoberts Jon J · Parker, COBuilt 1980 · S/N 172RG0573 N6091DMentone Flying Club · Rochester, INBuilt 1979 · S/N 17272599 N6091QBridges Jeffrey Kemp · Cumming, GABuilt 1965 · S/N 912 N6091VJames Jay C · Mesa, AZBuilt 1980 · S/N 172RG0574 N6092FJasper Aviation Inc · Jasper, ALBuilt 1979 · S/N 17273146 N6092MSchmucker Daniel · Bryn Athyn, PAS/N 15284619 N6092VAir Venture LLC · Au Gres, MIBuilt 1980 · S/N 172RG0575 N6093JAir S & T LLC · San Juan Capo, CAFirst renewal noticeBuilt 1980 · S/N 17273856 N6094FBuiqui Aerospace Corp · Kissimmee, FLBuilt 1979 · S/N 17273147 N6094QRakes Bobby N Jr · Saint Robert, MOBuilt 1965 · S/N 3261 N6096FColeman Gregory M · Chewelah, WABuilt 1966 · S/N 7ECA-352 N6097MPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1980 · S/N 15284621 N6097TDuffy Thomas J · Hollis, NHS/N R18201902 N6098DShurtleff Russell D · Tunkhannock, PABuilt 1979 · S/N 17272602 N6099QBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 3263 N6099WGriffith Aviation Co · Tulsa, OKBuilt 1981 · S/N P21000713 N609DCBarber Aircraft LLC · Topping, VABuilt 1975 · S/N 17265563 N609RLT And B Mgmt LLC · Las Vegas, NVBuilt 1979 · S/N 21063802 N60ACHaas Brent R · Willcox, AZBuilt 2019 · S/N 1475-2019 N60DWJohnson Boyd · Apple Valley, MNBuilt 1981 · S/N P21000696 N60GAGlidewell Aviation Inc · Parkland, FLBuilt 1978 · S/N 17271354 N60GLMiko Pawel Marcin · Santee, CABuilt 1978 · S/N 0806 N60GZAbl Aviation Inc Trustee · Wilmington, DEBuilt 1987 · S/N 24-3035 N60HEagle Flight Squadron Inc · East Orange, NJBuilt 1973 · S/N 17261653 N60HFTexas Flying Club Inc · Bryan, TXBuilt 1977 · S/N 17270210 N60JBHarmon Eagle LLC · Albuquerque, NMBuilt 1979 · S/N 483-79 N60LRBlake W Preston · Gainesville, FLBuilt 2003 · S/N 929-2003 N60MKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1981 · S/N P21000670 N60RPMartin Rolf M · Wellsburg, NYBuilt 1980 · S/N 24-1000 N60RSVolare Alto LLC · Sanford, NCBuilt 1980 · S/N P21000521 N60SGRichard Amster · Brookline, MABuilt 2011 · S/N 1461-2011 N60SSDhone Shridhar · Livermore, CABuilt 1968 · S/N 17257479 N60SXDitzler Enterprises Inc · Grinnell, IAS/N 15285148 N60XDIron Air LLC · Saint Albans, MOBuilt 2015 · S/N 1160-2015 N60YGLindstrom Dave C · Marinette, WIBuilt 1974 · S/N 17263953 N6100YRamsay Allan Trustee · Modesto, CABuilt 1981 · S/N 21064250 N6102HSunrise Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 15284131

Back to AD 80-25-07 R1