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.

N1601WSix Ten Ventures LLC · Grand Prairie, TXBuilt 1972 · S/N D-9360 N1603TMedcare Emergency Medical Services Inc · Mcallen, TXBuilt 1973 · S/N 414-0383 N1604MMckinney John Merrill Jr · Bessemer, ALBuilt 1983 · S/N TH1359 N1604WSteve Byrd Aviation LLC · Terrell, TXBuilt 1972 · S/N TH-242 N1605MSelter Eric Jay Trustee · Agoura Hills, CABuilt 1977 · S/N 21061950 N1609XHarvey P J · Midland, TXBuilt 1975 · S/N 21060645 N160DCPdii LLC · Concord, NCBuilt 1980 · S/N 421C0856 N160EUSkyfusion II LLC · Atlanta, GAFirst renewal noticeBuilt 2003 · S/N 0759 N160PBHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0493 N160SPAerospace Trust Management LLC Trustee · Wilmington, DES/N D-9615 N160UCrane Rental Service Inc · Tempe, AZBuilt 1960 · S/N CJ-9 N1613MMclaughlin Drew V · Anchorage, AKBuilt 1970 · S/N 18501833 N1615XBvi Aviation LLC · Wilmington, DEBuilt 1975 · S/N 21060651 N1618MFluckey Gary T · Homer, AKBuilt 1970 · S/N 18501834 N1618TRandolph James · Greensburg, PABuilt 1973 · S/N 414-0398 N1619WExecutive Aircraft Management LLC · Northport, ALBuilt 1972 · S/N TE-869 N161KCCk Aviation LLC · Melbourne, ARBuilt 1980 · S/N E-1700 N161RBower Fredrick S · Watervliet, MIS/N TE-365 N161RMTurbine Screws LLC · Bozeman, MTBuilt 1980 · S/N 414A0450 N161TRRambo Timothy B · Nampa, IDBuilt 1991 · S/N CE-1619 N161VPConservation Aviation LLC · Washington, DCBuilt 1971 · S/N U20601719 N161WCater Christopher B · Lowell, MIBuilt 1965 · S/N D-7914 N1621TBeats Driving Inc · Northbrook, ILBuilt 1973 · S/N 414-0401 N1622WN83993 LLC · Cherry Hill, NJExpired dealer, pending cancellationBuilt 1972 · S/N TE-870 N1624HSynergy Aviation LLC · Forest Lake, MNBuilt 1977 · S/N 18503317 N1624TMelnik Charles J DBA · Omaha, NES/N 414-0404 N1624WHill Travis · Smithville, TXBuilt 1972 · S/N CE-384 N1625CK&C Technologies LLC · Belleville, WIBuilt 2003 · S/N 0584 N1625UFly2k LLC · San Jose, CABuilt 1982 · S/N 21064710 N1625WGunter Professional Pilot Services LLC · Wichita Falls, TXBuilt 1972 · S/N D-9365 N1627TSierra Leasing LLC · Sheffield, ALBuilt 1973 · S/N 414-0407 N1628ZVertex Aviation LLC · Kodiak, AKBuilt 1962 · S/N 185-0428 N1629WRegistered aircraftN-number assigned, not yet registeredS/N TH-245 N162DFFaford Aviation Leasing Co · Atherton, CABuilt 1982 · S/N TJ-403 N162NBorgen Brian K · Osage Beach, MOBuilt 1966 · S/N TE-154 N162VPVirunga Airwing LLC · Washington, DCS/N U20606215 N1632WCdg Aviation LLC · Cresson, TXBuilt 1972 · S/N D-9363 N1633XRhodes Donald P · Fort Worth, TXBuilt 1975 · S/N 21060669 N1634WTaglieri Ronald F · Pass Christian, MSBuilt 1972 · S/N D-9378 N1634XBadwater Ranch Inc · Lysite, WYBuilt 1975 · S/N 21060670 N1635WTullos Hugh S III · Oklahoma City, OKBuilt 1972 · S/N E-350 N1636XMonke Farm & Cattle Co · Nickerson, NEBuilt 1975 · S/N 21060672 N1637TSmith Taylor · Amarillo, TXBuilt 1973 · S/N 414-0417 N163SPAgriflite Services Inc · Wakarusa, INBuilt 1972 · S/N TE-872 N163UHarbaugh Steven K · Austin, TXBuilt 1968 · S/N E-98 N1643EYoung Michael T · Flower Mound, TXBuilt 1992 · S/N CE1643 N1644MBrown James E · Duluth, MNBuilt 1970 · S/N 18501847 N1646TOrellana Willson Daniel · Hesperia, CABuilt 1973 · S/N 414-0426 N1647ZSantana Barry W · Wasilla, AKBuilt 1962 · S/N 185-0447 N164BBPorter Patrick J · Greensboro, NCBuilt 2004 · S/N 1128

Back to AD 86-13-04 R3