Registered aircraft · 18,497

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.

N2688DB2 Air LLC · Pierre, SDBuilt 1979 · S/N 414A0332 N2688MAlcyone Trust Corp Trustee · Wichita, KSBuilt 1979 · S/N 414A0334 N2688XDw Hamm Consulting LLC · Malibu, CABuilt 1979 · S/N 414A0336 N2689DRegistration Pending · Greenwood, MSRegistration pendingS/N 414A0401 N2689GShandog Air LLC · Ashland, KYBuilt 1979 · S/N 414A0402 N2689JFinley Taylor J · Colby, KSBuilt 1979 · S/N T18803497T N268CDKahng Jim · Torrance, CABuilt 2003 · S/N 0436 N268DLCrenshaw Robert L · Goldsboro, NCBuilt 1969 · S/N P206-0570 N268PBeaulot LLC · East Aurora, NYBuilt 2006 · S/N E-3750 N268RKalhart Transportation Services Inc · Rancho Santa Fe, CABuilt 1977 · S/N E1092 N2690AHamons Jeffery W · Perrysburg, OHBuilt 1978 · S/N E-1264 N2690JDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N T18803498T N2690TN633at LLC · Punta Gorda, FLS/N 414A0408 N2691YLa Paz Holdings LLC · Wetumpka, ALBuilt 1979 · S/N 414A0414 N2692LInnovative Aviators LLC · Norman, OKBuilt 1979 · S/N 414A0417 N2693BDiaz Charles · Ogden, UTBuilt 1979 · S/N 414A0422 N2693KKelman Naomi · Nashville, TNBuilt 1980 · S/N CE-820 N2694HRockingham Carriage Services Inc · Greenland, NHS/N 4140493 N2696HSunwest Aviation Inc · Santa Ynez, CAFirst renewal noticeBuilt 1979 · S/N 340A0778 N2696PBlue Wing Aviation LLC · Tulsa, OKBuilt 1979 · S/N 340A0779 N2696UBlack Dragon Consulting LLC · Phoenix, AZS/N 340A0780 N2699DN2699d Corp Trustee · Wilmington, DEBuilt 1979 · S/N 340A0787 N2699XAir Controls Billings Inc · Billings, MTBuilt 1966 · S/N P206-0199 N269FAir2615 LLC · Wilmington, DEBuilt 1968 · S/N 421-0177 N269KTJfa Aviation Group LLC · Pompano Beach, FLBuilt 1980 · S/N TJ-324 N269PCSch Aviation Inc Trustee · SporleBuilt 1979 · S/N 340A0785 N269R219 Air LLC · South Bend, INBuilt 1986 · S/N 8608065 N269RAFuller Aire Inc · Wilmington, DEBuilt 1978 · S/N TH-998 N269WTWillis James A · South Jordan, UTBuilt 1972 · S/N 340-0104 N26BRStender Aviation B LLC · Huntsville, ALBuilt 1983 · S/N E-2072 N26CFKustatan Leasing LLC · Nikiski, AKBuilt 1975 · S/N 20700306 N26CRSim International Inc · Fort Mill, SCBuilt 1973 · S/N 21060084 N26CSJetswiss LLC · Overland Park, KSBuilt 1993 · S/N E-2814 N26CUAnselmo Jeffery A · Fairfield, CABuilt 1986 · S/N U20606984 N26DLHayden David Bernard Trustee · Roach, MOBuilt 1973 · S/N 18502287 N26FCRwr Air Inc · Tok, AKBuilt 1974 · S/N U20602541 N26FFFastfun LLC · Fort Myers, FLBuilt 2004 · S/N 29-0352 N26GWRegistration Pending · Titusville, FLRegistration pendingBuilt 1969 · S/N 072 N26HAEpsilon Equity Partners LLC · Houston, TXS/N TJ-486 N26JJCrescenzo David G · Hammonton, NJBuilt 1975 · S/N TE-1058 N26KGarrett Robert A · Dallas, GABuilt 1954 · S/N G-57 N26KNSky King Aviation Inc · Weslaco, TXBuilt 1978 · S/N P21000085 N26LJN26lj LLC · Oklahoma City, OKBuilt 2012 · S/N TH-2352 N26PMHill Capital Leasing LLC · Scottsdale, AZBuilt 1977 · S/N 21061791 N26PVWoods H Ross · El Dorado, ARBuilt 1971 · S/N CE-347 N26QRSolesbee Nathan Arthur · Anaheim, CABuilt 1979 · S/N EA-19 N26RGPlane Fun Inc Tr Trustee · Snellville, GABuilt 1987 · S/N E-2383 N26RSStacey Enterprises Inc · Ogden, UTBuilt 1978 · S/N P21000153 N26RTInternational Air Services Inc Trustee · Carson City, NVBuilt 1988 · S/N CE-1292 N26SKDevine Robert · Albuquerque, NMBuilt 1994 · S/N 87

Back to AD 86-13-04 R3