Registered aircraft · 54,015

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.

N719LCYoung Larry W · Bowdoin, MES/N 18259514 N71CNAnderson Thomas R · Seattle, WAS/N 18053113 N71CPKitty Hawk Flight Training And Tours LLC · Nags Head, NCBuilt 1972 · S/N 15073229 N71CWSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 18051093 N71DCDish Technologies LLC · Rocky Mount, NCBuilt 1960 · S/N 52803 N71DJBlitman Jeffrey W · Wellington, FLBuilt 1973 · S/N 18261969 N71ERClapp William H · Mountain View, MOBuilt 1968 · S/N 180-51965 N71ESBig Tex LLC · Reedsburg, WIS/N U206-1402 N71HHEastern Slope Aviation Academy · North Conway, NHBuilt 1971 · S/N 17260295 N71JHJacks Air Serv Inc · Greenville, MEBuilt 1966 · S/N 18051678 N71JTJav Air Services LLC · Anchorage, AKBuilt 1978 · S/N 18266696 N71KFFoster Kenneth B · Queen Creek, AZBuilt 1977 · S/N 18265723 N71MHSchultz Engineered Products Inc · Neptune, NJBuilt 1978 · S/N 18052965 N71MJ1mj LLC · Willis, TXBuilt 1979 · S/N 18267250 N71MKWyeth Patrick · Chino Valley, AZBuilt 1980 · S/N P21000590 N71MVVolatile Aero Ventures LLC · Boulder City, NVFirst renewal noticeBuilt 1974 · S/N U20602365 N71MWWalker Michael E · Lewistown, MTS/N 51266 N71PHPlh Air LLC · Post Falls, IDBuilt 1975 · S/N U20602651 N71PKBob Hoover Academy · Salinas, CABuilt 1974 · S/N 17263272 N71RTaliaferro Aviation LLC · Ardmore, OKS/N 18503942 N71SNorth Pine Properties LLC · Queen Creek, AZBuilt 1974 · S/N P3370171 N71STGreen Martin H · Framingham, MABuilt 1978 · S/N 18266651 N71TDDunn William F · Del Norte, COBuilt 1957 · S/N 29706 N71TFFreund Timothy P · Goddard, KSBuilt 1956 · S/N 32587 N71WFRobins David M · Tehachapi, CAS/N R18200618 N71WTBear Cat Air LLC · Gun Barrel City, TXS/N 21061505 N7200AMcdaniel Neil R · Wray, COBuilt 1956 · S/N 29300 N7200EAircraft Structural Repair Inc · Hamilton, MTBuilt 1959 · S/N 52200 N7200GWe Fly High LLC · Helena, MTBuilt 1969 · S/N 17258900 N7200QFisher Eric C · San Francisco, CABuilt 1972 · S/N 17260500 N7200TYavitch Barry E · Palmdale, CABuilt 1959 · S/N 46800 N7200XGloris Robert J · Lago Vista, TXBuilt 1961 · S/N 15059300 N7201ACarleson Jesse R · Wasilla, AKFirst renewal noticeBuilt 1956 · S/N 29301 N7201THorton Rusty Ray · Monroe, GABuilt 1959 · S/N 46801 N72027Candy Corn LLC · Missoula, MTBuilt 1968 · S/N U206-1259 N7202EAlbertson James M · Westville, FLBuilt 1959 · S/N 52202 N7202GUrmston Benjamin R · Sherborn, MABuilt 1969 · S/N 17258902 N7202TArcangeli Harry L · Lakemont, NYBuilt 1959 · S/N 46802 N7202XFielding John N · Scarborough, MEBuilt 1961 · S/N 15059302 N72035Christiano Brett T · Pasco, WABuilt 1967 · S/N 17700240 N7203AJohnson Lawrence F · Anchorage, AKBuilt 1956 · S/N 29303 N7203GVenard Inc · Murdo, SDS/N 17258903 N7203TRegistration Pending · Amarillo, TXRegistration pending, pending cancellationBuilt 1959 · S/N 46803 N7204GGibson James E · Tenino, WABuilt 1969 · S/N 17258904 N7204QTexas Air Rangers LLC · Mckinney, TXBuilt 1972 · S/N 17260504 N7204SAerolab LLC · Hartwell, GAS/N 15067904 N7204TGaponoff Mark A · Mercer Island, WAFirst renewal noticeBuilt 1960 · S/N 46804 N72050Petty Line Const Co Inc · Clanton, ALBuilt 1969 · S/N U206-1266 N7205GJones Keith · Tucson, AZBuilt 1969 · S/N 17258905 N7205NMontgomery Gary Mark · Mineral Wells, TXBuilt 1974 · S/N 18262997

Back to AD 87-20-03 R2