Registered aircraft · 22,416

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:87-08-08-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3') 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:87-08-08-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
  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:87-08-08-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
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.

N6994JLytle Tobin A · Grove, OKBuilt 1976 · S/N 28-7625266 N6994WCone Carl T · Statesboro, GABuilt 1965 · S/N 28-21193 N6995CDetert Bradley · Valparaiso, INBuilt 1978 · S/N 28R-7837180 N6996WGiles David · Augusta, GABuilt 1965 · S/N 28-21195 N6997JBailey Kevin R · Crown Point, INBuilt 1976 · S/N 28-7690452 N6997WKeeter Michael P · Proberta, CABuilt 1965 · S/N 28-21196 N6998JMt Aircraft Sales And Leasing LLC · Wilmington, DEBuilt 1976 · S/N 28-7690453 N6998NPacifica LLC · Grand Junction, COS/N 28R-35797 N6998WTutunik Aleksandr · Lake Hughes, CAS/N 28-21197 N6999JSun West Aviation Inc · Santa Ynez, CABuilt 1976 · S/N 28R-7635373 N6999WSilva Javier · Sanger, TXBuilt 1965 · S/N 28-21198 N699DWDw Flight LLC · Columbus, OHBuilt 2005 · S/N 2843612 N699FLEdgewood Acres LLC · Willmar, MNS/N 28-7225193 N699GWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1987 · S/N 3213004 N699LGN699 Lg LLC · Mahtomedi, MNBuilt 1999 · S/N 2843258 N699LHFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 2881687 N699RBMaoz Eyal Trustee · New York, NYBuilt 1963 · S/N 28-10048 N699SPMa Aviation LLC · Danville, ILBuilt 1996 · S/N 3246023 N69APScott Brady · Manakin-Sabot, VABuilt 1969 · S/N 28-25658 N69FMAirtime LLC · South Lyon, MIBuilt 1976 · S/N 32R-7680200 N69GSDaphnee Moise Md Pa · Sarasota, FLBuilt 1972 · S/N 28R-7235275 N69KYAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1973 · S/N 28-7305300 N69LHGraham Jack · Hamilton, TXBuilt 1977 · S/N 32R-7780323 N69LVTbd Air LLC · Chatham, MABuilt 2001 · S/N 3257229 N69MKFisher Jack C · Ashland City, TNBuilt 1998 · S/N 3257063 N69MWOlson James H · Eleva, WIBuilt 1975 · S/N 28R-7635064 N69PAWanagel Joshua · Berwyn, PABuilt 1969 · S/N 28R-35159 N69PZParagon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020182 N69RRInternational Air Services Inc Trustee · Carson City, NVBuilt 1966 · S/N 32-516 N69RSBerry Brian R · Tahlequah, OKBuilt 1979 · S/N 28R-7931305 N69TZUnder The Radar LLC · Henderson, NVBuilt 2006 · S/N 2843640 N69WPHutcheson Jon · Greencastle, INBuilt 1973 · S/N 32-7440015 N6ECDraco Flight School Inc · Chino, CABuilt 1974 · S/N 28R-7435220 N6FGSmith Timothy S · Kinston, NCBuilt 1974 · S/N 28-7425297 N6FTBrotman Bruce · Morgantown, WVBuilt 1966 · S/N 32-336 N6JZFaith Church Of Sherman · Sherman, TXBuilt 2003 · S/N 3232003 N6MRBeezyflyin LLC · Chesapeake, VABuilt 1972 · S/N 28-7205270 N6NHStephens Timothy D · Springfield, MOBuilt 1966 · S/N 28-3698 N6NSWestern Flying Club Inc · Burlington, NCBuilt 1978 · S/N 28-7990206 N6UKN6uk LLC · Goshen, INBuilt 1978 · S/N 32-7840123 N6WEHigh Flight Aviation LLC · Harwinton, CTBuilt 1993 · S/N 3213050 N6YVZadrozny Pedro A · Wellington, FLBuilt 1978 · S/N 32R-7885160 N7000RJilek Peter Andrew · River Falls, WIBuilt 1966 · S/N 28-21693 N7000WIndy Air Sales LLC · Anderson, INBuilt 1962 · S/N 28-671 N7000XWalsh Peter F · Walpole, MABuilt 1971 · S/N 28R-7135172 N7001WBrinc LLC · Lancaster, PABuilt 1963 · S/N 28-673 N7004FSouthern Vector Aerospace LLC · Huntsville, ALS/N 28-7790176 N7004REasley Leroy · Novelty, MOFirst renewal noticeBuilt 1966 · S/N 28-21698 N7004WLettsome Nesco · Beltsville, MDBuilt 1962 · S/N 28-676 N7005Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020180

Back to AD 87-08-08 R3