Registered aircraft · 18,495

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:86-13-04-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:86-13-04-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:86-13-04-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:86-13-04-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:86-13-04-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:86-13-04-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.

N737ELCsi Flight Services LLC · Mcminnville, ORS/N EA-127 N737PM & E Horizons LLC · Slatington, PABuilt 1994 · S/N E-2908 N7380HCoggins Craig C · Nome, AKS/N 18503384 N7382VDunbar Stephen Trustee · Broken Arrow, OKBuilt 1969 · S/N 30235 N7384CFesco Holdings Inc · Alice, TXBuilt 1980 · S/N 21063951 N7384UGrant Aviation Inc · Anchorage, AKBuilt 1978 · S/N 20700431 N7385RCw Aircraft LLC · Atlanta, GABuilt 1976 · S/N TH-734 N7385WRegistered aircraftN-number assigned, not yet registeredS/N E-3773 N7386CAgro Engineering Inc · Alamosa, COBuilt 1977 · S/N U20603916 N7386VJenkins Jerome D · Gays Mills, WIBuilt 1969 · S/N 30238 N7388RPeitz Russell W · Sebring, FLBuilt 1974 · S/N E565 N7389UYr-Aircraft Leasing LLC · Bethel, AKBuilt 1978 · S/N 20700432 N7389VLascar Amado J · Urbana, ILBuilt 1969 · S/N 30224 N738TFester John P · Sullivan, MOS/N TH-706 N7391PShph LLC · Edwards, ILBuilt 1978 · S/N P21000011 N7391REdm Corporation · Nevada, MOBuilt 1974 · S/N D-9651 N7392RJohnson Franklin H · Tyler, TXBuilt 1974 · S/N E-579 N7392USpernak Airways Inc · Anchorage, AKFirst renewal noticeBuilt 1978 · S/N 20700435 N7395HWild Alaska Real Estate LLC · Anchorage, AKBuilt 1977 · S/N 18503388 N7396RBaja Aviation LLC · Northbrook, ILBuilt 1974 · S/N E-580 N7396UAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1978 · S/N 20700438 N7397RWest Michael P · Colusa, CABuilt 1974 · S/N D-9654 N739MCaurus Power Inc · Santa Rosa, CABuilt 1978 · S/N P21000063 N73BJJewett Brandon M · Brighton, COBuilt 1975 · S/N 18502798 N73CAShelor Investments LLC · Christiansburg, VAS/N TH-1889 N73DEHill Christopher Michael · Linden, TXBuilt 1976 · S/N D-9909 N73EKOgrin Kirk W · Bigfork, MTBuilt 1978 · S/N 18503464 N73EPColburn & Associates LLC · Woodruff, SCBuilt 1973 · S/N 340-0240 N73FPDunn Frederick C Jr · Fayetteville, GABuilt 1968 · S/N CJ-5 N73HW73 Hotel Whiskey Llp · West Fargo, NDBuilt 1979 · S/N TJ-223 N73JJJj Ventures LLC · Billings, MTBuilt 1981 · S/N 18504241 N73JWKiang Justin · Simi Valley, CABuilt 1974 · S/N TE-982 N73KDRegistered aircraftBuilt 2009 · S/N LES-169 N73KPRuiz Teresa M · Lakewood Ranch, FLBuilt 1973 · S/N 73-32-115 N73LLT3 Aviation LLC · Oak Point, TXBuilt 1977 · S/N 21062163 N73MKKauffman Nicole A · Lincoln Park, NJBuilt 1966 · S/N TE-153 N73RHBradley A Eli Dental Corp · Encinitas, CABuilt 1973 · S/N D-9487 N73SMBrown Michael · Gardnerville, NVS/N E-2961 N73TBMagic Leasing LLC · Peotone, ILBuilt 1981 · S/N 414A0474 N73TXSee Robert W · Catawba, NCBuilt 2001 · S/N 40034 N73VBVb Aviation LLC · Mount Pleasant, SCBuilt 1973 · S/N D-9534 N73WTBa Cane Aviation LLC · Weston, FLBuilt 2005 · S/N 1387 N740United States Department Of Interior · Boise, IDBuilt 1980 · S/N U20605724 N7402QRichs Alaskan Flying Adventures LLC · Wasilla, AKBuilt 1973 · S/N U20602192 N740AGStefenelli Aviation N-Tr Inc Trustee · AtterseeS/N 421A-0033 N740CAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0277 N740WJAlm Holding LLC · Winton, CABuilt 1979 · S/N 340A0740 N741DFSeeding Operations And Atmospheric Res (Soar) LLC · San Angelo, TXBuilt 1975 · S/N 414-0633 N741ESSmith Edward B · Slidell, LABuilt 1981 · S/N E-1915 N741JBBrendel James G · Scottsdale, AZBuilt 1968 · S/N D-8701

Back to AD 86-13-04 R3