Registered aircraft · 54,019

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

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 N185WPArrowhead Holdings Inc · Wilmington, DEBuilt 1979 · S/N 18503936 N185WRNorthwoods Aviation Inc · Cadillac, MIBuilt 1976 · S/N 18503121 N185WSStotlar William B · Pinckneyville, ILBuilt 1971 · S/N 18501855 N185WTPenley Robert G · Corinth, TXBuilt 1972 · S/N 15073919 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 N185XSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N 18504220 N185XLBryant Theodore M · Wasilla, AKBuilt 1981 · S/N 18504211 N185XSJepsen John S · Anchorage, AKBuilt 1977 · S/N 18503315 N185XVN185xv LLC · Austin, TXS/N 18503778 N185YLee Bryan D · Rexburg, IDFirst renewal noticeS/N 18502224 N185YHMcdaniel Robert M · Tonasket, WAS/N 18503551 N185YMBarber Michael E · Prescott Valley, AZBuilt 1977 · S/N 18503441 N185YTSutton Aircraft Salvage LLC · Palmer, AKS/N 185-0145 N185YVCul-Aircorp Inc · Wellington, FLBuilt 1978 · S/N 18503546 N185YYDagostino Thomas J · Wasilla, AKS/N 18503195 N185ZWab Air LLC · Butte, MTBuilt 1968 · S/N 1851363 N185ZAPlane Fun Inc Tr Trustee · Snellville, GABuilt 1965 · S/N 185-0983 N185ZMDragon Wagon LLC · Clackamas, ORBuilt 1981 · S/N 18504324 N185ZZLeading Edge LLC · Scottsdale, AZBuilt 1966 · S/N 185-1029 N18602Poston James M · Hixson, TNBuilt 1976 · S/N 17702544 N1860YPeterson Jerad · Oshkosh, NES/N 17249460 N18612Missoula Fliers LLC · Milltown, MTBuilt 1972 · S/N 15073987 N18618Hammons Bryan S · Stephenville, TXBuilt 1972 · S/N 15073991 N1861CSierra Flying Club LLC · Woodinville, WABuilt 1953 · S/N 26005 N1861XCabreja Sanchez Elmer · Carolina, PRBuilt 1964 · S/N 18255961 N1861ZPadden Geary L · Duluth, MNBuilt 1962 · S/N 205-0061 N18623Fleischmann Fred · Racine, WIBuilt 1972 · S/N 15073994 N18627Oberhansly Lucas C · Roy, WABuilt 1972 · S/N 15073998 N18628Paul William A · Windfall, INBuilt 1972 · S/N 15073999 N1862CCoffey Calvin A · Mckinney, TXBuilt 1953 · S/N 26006 N1862QB & P Transportation LLC · Mount Blanchard, OHBuilt 1972 · S/N 177RG0262 N1862XCose Gary D · Livermore, CABuilt 1964 · S/N 18255962 N1862YVakalis Kevin A · Chugiak, AKBuilt 1962 · S/N 17249462 N18630Gaddy Tyler Quintin · Advance, NCBuilt 1972 · S/N 15074000

Back to AD 87-20-03 R2