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.

N18SGBennett Jeannette DBA · Joiner, ARFirst renewal noticeBuilt 1975 · S/N 310R0560 N18TN18t Ltd · Wilmington, DEBuilt 1968 · S/N 421-0144 N18TUCheck Seven LLC · Champaign, ILBuilt 1967 · S/N D-8450 N18VGBullet Aviation LLC · Missoula, MTBuilt 1999 · S/N E-3255 N18VJAssurance Data Inc · Indiana, PABuilt 1984 · S/N TJ-445 N18VRVentura Air LLC · Wilmington, DEBuilt 1996 · S/N TH-1771 N18VUVincennes University · Vincennes, INBuilt 1977 · S/N 310R0928 N18WPPacker William M · Orchard Lake, MIBuilt 1966 · S/N D-8125 N18WWFourth Sister LLC · Wilmington, DEBuilt 1994 · S/N E-2860 N18XBecker James · Crystal Lake, ILBuilt 1978 · S/N E-1353 N1901LBerry Darrel · Camden, TNBuilt 1976 · S/N TH-754 N1903LN1903l LLC · Jacksonville, FLBuilt 1976 · S/N D-9900 N1905B605 Aviation LLC · Aberdeen, SDBuilt 1978 · S/N 414A0214 N1905ERusso Louis A Jr · Houston, TXBuilt 1979 · S/N 340A0664 N1905ULeichtfuss Brad · Lake Havasu City, AZBuilt 1973 · S/N U20602275 N1906FP206-1 LLC · Carrollton, GABuilt 1964 · S/N P206-0001 N1908GAir Z Flying Service Inc · Richmond Heights, OHBuilt 1974 · S/N 310R0055 N1909L52 Foxtrot Aviation LLC · Billings, MTBuilt 1976 · S/N D-9901 N190CCWayside LLC · Wilmington, DEBuilt 1984 · S/N 46-8408045 N190DRLehrke Thomas Alan · Bloomington, MNBuilt 2001 · S/N 29-0279 N190DWSouthern Sky Ventures LLC · Lewes, DEBuilt 2003 · S/N 42002 N190P98 Mike LLC · Hayden, IDBuilt 1964 · S/N P206-0012 N190QMcgilvray Saxon · Helena, MTBuilt 1964 · S/N D-7551 N1911JD M C Aviation LLC · Jennings, LABuilt 1971 · S/N E-298 N1912LRegistered aircraftBuilt 1976 · S/N E-866 N1913LBas Part Sales LLC · Greeley, COBuilt 1976 · S/N CE-656 N1915WPasha Mohammad A · Muscatine, IABuilt 1971 · S/N 310Q0429 N1917UPinewood Homes LLC · Hayward, WIBuilt 1969 · S/N 185-1588 N1918EGuano Air LLC · Palmetto Bay, FLBuilt 1979 · S/N 340A0668 N1919JValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 310R1554 N1919LSmith Sydney O · Lithonia, GAS/N 411-0157 N1919VHigh Mountain Properties LLC · Idaho Falls, IDBuilt 1984 · S/N T30300271 N191BFKoziura Sebastian · Evanston, ILBuilt 1991 · S/N CE-1577 N191CCCarter Cleveland M · Willacoochee, GABuilt 1972 · S/N CE-399 N191CTBessemer Plywood Corp · Bessemer, MIBuilt 1974 · S/N 310R0057 N191DWLexo Enterpirses · Houston, TXBuilt 2003 · S/N 42022 N191JHJack Henry And Associates Inc · Monett, MOBuilt 1982 · S/N E-2042 N191KMDodson International Parts Inc · Rantoul, KSS/N 0017 N191LRRoutman Leone Aircraft LLC · Fort Lauderdale, FLBuilt 1994 · S/N TH-1720 N191WEFs Mickey LLC · East Lansing, MIBuilt 1975 · S/N TE-1059 N191YPlatte Valley Air LLC · Columbus, NEBuilt 1966 · S/N D-8172 N1920EHappy Trails Flight Training & Charters LLC · Helena, MTBuilt 1979 · S/N 340A0669 N1920QAcadian Aircraft Leasing LLC · Rangeley, MEBuilt 1977 · S/N 18503502 N1922TBiscoe Donald M · Cottage Grove, MNBuilt 1969 · S/N 21059220 N1922UFriedrich Richard R · Newtown, CTS/N 185-1593 N1926QVonimhof Rudolph F · Anchorage, AKBuilt 1977 · S/N 18503503 N1926UBarrett Michael D · Anchorage, AKBuilt 1973 · S/N U20602287 N1928TWalters Jonathan · Malvern, OHBuilt 1990 · S/N CE-1533 N192AFWarren E Mack LLC · Minneapolis, MNBuilt 1980 · S/N 414A0496 N192AGBp Aviation LLC · Gilbert, AZBuilt 2005 · S/N 29-0406

Back to AD 86-13-04 R3