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.

N7432TWilcox Joshua · Mesa, AZBuilt 1959 · S/N 47032 N7432XFerguson Mark G · Wallkill, NYBuilt 1960 · S/N 17247932 N7433ASmith Larry D · Friendswood, TXBuilt 1956 · S/N 29533 N7433GStyles Brian P · Cullman, ALBuilt 1970 · S/N 17259133 N7433NFixed Gear LLC · Sherwood, ARBuilt 1977 · S/N U20603660 N7433TAndreatta Susan J · Canon City, COBuilt 1959 · S/N 47033 N7434QD'Ambrosia Louis E · Chardon, OHBuilt 1972 · S/N 18261074 N7434TDixon Farm · Tribune, KSS/N 47034 N7435NPieretti George L · Sacramento, CABuilt 1974 · S/N 18263213 N7435TJohnson Scott E · Wausau, WIBuilt 1959 · S/N 47035 N7435XRoduner Cindy J · Benton, KSS/N 17247935 N7436EFreedom Airforce · Albuquerque, NMBuilt 1960 · S/N 57136 N7436GChickadee Aviation LLC · Rangeley, MEBuilt 1970 · S/N 17259136 N7436QStefanowicz Chester J · Baltimore, MDBuilt 1972 · S/N 18261076 N7437NSundance Aero LLC · Mertzon, TXBuilt 1974 · S/N 18263215 N7438AKellogg Charlie H · Oxnard, CABuilt 1956 · S/N 29538 N7438EWalker Jim O · Lovell, WYBuilt 1960 · S/N 57138 N7438GMcguinnis Joseph G · Scottsdale, AZBuilt 1973 · S/N 15074655 N7438NMockler Sarah Margaret · Awendaw, SCBuilt 1974 · S/N 18263216 N7439AAlsterlind Stephen W · San Rafael, CABuilt 1956 · S/N 29539 N7439GScheck Doug J · Medina, OHBuilt 1970 · S/N 17259139 N7439MBrooks Randall L · Queen Creek, AZBuilt 1958 · S/N 55739 N7439QSpoer Jonathan M · Agoura Hills, CABuilt 1972 · S/N 18261079 N743ASA2g International LLC · San Juan Capo, CABuilt 1975 · S/N 33701647 N743HLanoue Edgar A · Stevensville, MTBuilt 1969 · S/N U206-1297 N743KSBarrett Buford L · Bristol, VABuilt 1976 · S/N 18052710 N743RBBenefield Shelby · Attalla, ALS/N 15072497 N7440AN7440a LLC · Howell, MIBuilt 1956 · S/N 29540 N7440EWilson Colton M · Wellsville, UTS/N 57140 N7440GJohnes Charles H · Santa Maria, CABuilt 1973 · S/N 15074656 N7440MAustin Kevin · Roseville, CABuilt 1959 · S/N 55740 N7440NDrewes Farms Inc · Craig, MOS/N 18263218 N7440QAircraft Holding LLC · Orem, UTBuilt 1972 · S/N 18261080 N7440TFranklin Benjamin L Jr · Woodstock, GABuilt 1960 · S/N 47040 N7440XWatonwan Flyers Inc · Saint James, MNBuilt 1960 · S/N 17247940 N7441AMadison Nicholas R · Fayette, ALBuilt 1959 · S/N 29541 N7441GSussex Aero Maintenance Inc · Georgetown, DEBuilt 1970 · S/N 17259141 N7441NAir Impressions Inc · Waco, TXBuilt 1974 · S/N 18263219 N7441QSelinger Melvin · Arcata, CABuilt 1972 · S/N 18261081 N7441TGarst Lynn F · Oklahoma City, OKBuilt 1959 · S/N 47041 N7441XHolland Newel G · Nacogdoches, TXBuilt 1960 · S/N 17247941 N7442TTrono Zach C · Charlotte, VTBuilt 1959 · S/N 47042 N7442XBeail Herschel D · Quincy, CABuilt 1960 · S/N 17247942 N7443MVaccari Kevin N · Walnut Ridge, ARBuilt 1959 · S/N 55743 N7443TGuarno Adam C · Milton, FLS/N 47043 N7444MMitchell Lester L · Okmulgee, OKBuilt 1958 · S/N 55744 N7444QGroffman Armand Rossini · Los Alamos, NMBuilt 1972 · S/N 18261084 N7444TDmac Aircraft LLC · Savannah, GABuilt 1959 · S/N 47044 N7445EElite Aircraft Sales LLC · Searcy, ARFirst renewal noticeS/N 57145 N7445NSkyplane Pilots LLC · Bluffton, SCS/N 18263223

Back to AD 87-20-03 R2