Registered aircraft · 18,498

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.

N1797RNorthstar Holdings LLC · Anchorage, AKBuilt 1981 · S/N U20606331 N1797XN1797x Aero LLC · Gulf Breeze, FLBuilt 1975 · S/N 21060817 N17980Rowles Robert · Pittsfield, ILBuilt 1977 · S/N TH-840 N1798RSedwick Jack D III · Anchorage, AKBuilt 1974 · S/N 18502514 N1798XN1798x LLC · Etna Green, INBuilt 1975 · S/N 21060818 N179AKCrp Research LLC · Fenton, MIBuilt 2017 · S/N E-4101 N179KDTblc LLC · Princeton, NJBuilt 1967 · S/N D-8519 N179MCFulton Rick D · Marble Falls, TXBuilt 1990 · S/N CE-1530 N179RMyers Aviation Inc · Oshkosh, WIBuilt 1978 · S/N D-10179 N179TWBlue Sky Aviation Investments LLC · Coconut Creek, FLBuilt 1979 · S/N 79-30957 N17AMFarmdog Aviation LLC · Lafayette, INBuilt 1974 · S/N 414-0524 N17BRJds Management Co LLC · Warner Robins, GABuilt 1983 · S/N TH-1372 N17CBCygnet Aerospace Corp · Los Osos, CABuilt 1966 · S/N D-8232 N17CCReinhart Alan · Ventura, CABuilt 1969 · S/N D-9087 N17CDDroddy Charles V · Bryan, TXBuilt 1976 · S/N E-931 N17CJ16d Aviation LLC · Vashon, WABuilt 1968 · S/N U206-1199 N17DCShaw Richard A · Redondo Beach, CABuilt 1950 · S/N D-2669 N17EARegistration Pending · Melbourne, FLRegistration pendingBuilt 1997 · S/N E-3092 N17ESCrimson Aviation LLC · New York, NYBuilt 1985 · S/N TJ-488 N17FECox Matthew B · Russiaville, INBuilt 1979 · S/N D-10280 N17GNGrant Aviation Inc · Anchorage, AKBuilt 1981 · S/N 20700693 N17GPRed River Partners LLC · Edmond, OKBuilt 1979 · S/N TJ-210 N17GVVolker Management LLC · Panama City Beach, FLBuilt 1972 · S/N E-343 N17HLRiley Charles S · Littleton, COS/N 421B-0310 N17HSRed Oak Centurion LLC · Red Oak, IABuilt 1967 · S/N 21058844 N17JJN17jj LLC · Punta Gorda, FLBuilt 2004 · S/N L2K-229 N17JKCobb Henry Hammond IV · Montgomery, ALBuilt 2008 · S/N E-3886 N17JYYorkavitz James B · Valley City, OHBuilt 1969 · S/N 21059154 N17KEYanity Nicholas A · Woodinville, WABuilt 2005 · S/N 1358 N17KRMerriam Lowell · Chowchilla, CABuilt 1966 · S/N TE-210 N17LGGreen & Green Construction Of Grenada Inc · Grenada, MSBuilt 1966 · S/N TE-204 N17LVMountain Cascade Inc · Livermore, CABuilt 2015 · S/N E-4062 N17MABearden James D · West Point, MSS/N D-7529 N17NGParmer Construction Company LLC · Terrell, TXBuilt 1987 · S/N 4608074 N17NWEye Clinic Building Lllp · Bismarck, NDBuilt 1979 · S/N 414A0223 N17PKSmith Kevin B · Camden, NCBuilt 1964 · S/N D-7515 N17REFarina Richard H · Ashburn, VAS/N CE-1128 N17SNWindspeed LLC · Amarillo, TXBuilt 2001 · S/N 0115 N17SRNcsb LLC · Anchorage, AKBuilt 1974 · S/N 18502424 N17TCKenyon Walter C · Eureka Springs, ARBuilt 1964 · S/N 21058499 N17UKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2002 · S/N 0200 N17USMarmac Inc · Hellertown, PABuilt 1976 · S/N E-851 N17WFDraper Russell E · Camarillo, CABuilt 1978 · S/N D-10191 N17WZJuanje Air LLC · Newtown Square, PABuilt 2013 · S/N E-3983 N1800FReid Brian M · Boise, IDBuilt 1965 · S/N 21058700 N1800HSanders Trent J · Redway, CABuilt 2003 · S/N 42009 N1800VRegistered aircraftS/N E-1858 N1801MIrish Christopher J · Overland Park, KSBuilt 1981 · S/N CE-953 N1802FSantiago Ferdinand · Calhoun, GABuilt 1965 · S/N 21058702 N1802RMontaska Management Inc · Anchorage, AKBuilt 1974 · S/N 18502518

Back to AD 86-13-04 R3