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.

N185SKGulf Sierra Aviation LLC · Owasso, OKBuilt 1980 · S/N 18504151 N185SLDepartment Of Inland Fisheries And Wildlife · Augusta, MEBuilt 1981 · S/N 18504316 N185SMThompson Steven Trustee · Ardmore, OKBuilt 1976 · S/N 18503068 N185SNJones Kyle H · Anchorage, AKBuilt 1972 · S/N 185-01943 N185SPAltschuler Elmer E · Soldotna, AKBuilt 1976 · S/N 18503175 N185SQSnider Helicopter Service LLC · Turner, MTBuilt 1977 · S/N 18503306 N185SSRose Harlan Bryan · Lubbock, TXBuilt 1974 · S/N 18502389 N185STTerry D Stewart · Anchorage, AKBuilt 1978 · S/N 18503571 N185SVHanst David L · Carson City, NVBuilt 1980 · S/N 18504019 N185SWK And S Aviation Inc · Pagosa Springs, COBuilt 1977 · S/N 18503199 N185SZBredin Thomas W · Anchorage, AKBuilt 1969 · S/N 185-1589 N185THsr Creative LLC · Indian Trail, NCS/N D-9672 N185TBJohnson Nathan L · Fairbanks, AKBuilt 1980 · S/N 18504008 N185TCMontana Jet LLC · Bozeman, MTBuilt 1976 · S/N 18502890 N185TDHagl Aviation LLC · Sunray, TXBuilt 1980 · S/N 18504136 N185THPort Michael J · Twisp, WABuilt 1977 · S/N 18503456 N185TJMuchow Craig R · Gooding, IDFirst renewal noticeBuilt 1969 · S/N 185-1532 N185TKKoff Thomas R · Santa Paula, CABuilt 1981 · S/N 18504366 N185TM1521 LLC · Antigo, WIBuilt 1976 · S/N 18502984 N185TNRw Skywagons LLC · Manitowish Waters, WIBuilt 1974 · S/N 18502469 N185TPDal Porto Donna L · Nampa, IDBuilt 1967 · S/N 185-1234 N185TSParks Timothy R · Chesterfield, MOS/N 18504245 N185TTLucky Irishman LLC · Pebble Beach, CABuilt 1978 · S/N 18503634 N185TWUnited States Air Force · Jber, AKBuilt 1979 · S/N 18503945 N185TXSale Reported · Montgomery, TXSale reportedBuilt 1974 · S/N 18502500 N185USUS Aviation.Com LLC · Moorestown, NJBuilt 1977 · S/N 18503419 N185VEXit Concrete Inc · Dalhart, TXBuilt 1981 · S/N 18504240 N185VGDonovan Michael S · Albuquerque, NMBuilt 1979 · S/N 18503930 N185VHGreen Daniel H · Eagle River, AKBuilt 1976 · S/N 18502987 N185VKPoint Two Mmo Aviation · Lake Stevens, WABuilt 1975 · S/N 18502803 N185VMGardner Marvin L II · Addison, TXBuilt 1984 · S/N 18504422 N185VPSongbird Aviation Services LLC · Wilmington, DEBuilt 1978 · S/N 18503547 N185VVJetran LLC · Horseshoe Bay, TXBuilt 1985 · S/N 18504435 N185WZeiger William O Jr · Bend, ORBuilt 1978 · S/N 18503589 N185WAEverel Floatplane LLC · Sandia Park, NMBuilt 1976 · S/N 18503054 N185WBFodor Scott M · Barryton, MIBuilt 1980 · S/N 18504105 N185WCSindelir Randall L · Columbia Falls, MTBuilt 1970 · S/N 18501771 N185WFLewis Clyde · Anchorage, AKBuilt 1972 · S/N 18502005 N185WGPioneer General Engineering Inc · Fallon, NVBuilt 1977 · S/N 18503193 N185WKIntrepid Air LLC · Palmer, AKBuilt 1970 · S/N 185-01832 N185WMWithrotor Aviation Inc · Lakeview, ORBuilt 1967 · S/N 185-1215 N185WSStotlar William B · Pinckneyville, ILBuilt 1971 · S/N 18501855 N185WVScenic Air LLC · Kalispell, MTBuilt 1977 · S/N 18503252 N185WWWright John M · Bellevue, IDBuilt 1981 · S/N 18504310 N185WXChew Scott E · Estes Park, COBuilt 1975 · S/N 18502633 N185WYBrantner Brian P · Spokane Valley, WABuilt 1967 · S/N 185-1229 N185WZB H Hildebrand Construction Inc · Cataldo, IDBuilt 1980 · S/N 18504102 N185XLBryant Theodore M · Wasilla, AKBuilt 1981 · S/N 18504211 N185XSJepsen John S · Anchorage, AKBuilt 1977 · S/N 18503315 N185XVN185xv LLC · Austin, TXS/N 18503778

Back to AD 86-13-04 R3