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.

N718APAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1977 · S/N 21061857 N718DFTurning Point @ Sonrise Inc · Hartsville, TNBuilt 1964 · S/N 17251190 N718JSBrewster Scott · Sedona, AZS/N 18265417 N718MJValiair Ltd Co Trustee · Casper, WYBuilt 1978 · S/N R18200461 N718RWWestern Skymasters LLC · Salt Lake City, UTS/N P3370211 N71900Savage David E · American Falls, IDBuilt 1968 · S/N U206-1217 N71908Mielke Martin W · Valley City, OHBuilt 1973 · S/N 33701500 N7190EBrown Hector M · Glenwood Springs, COS/N 52190 N7190GM T Machinery Inc · Porter, TXBuilt 1969 · S/N 17258890 N7190MDiener John M · Stephenville, TXBuilt 1958 · S/N 55490 N7191GHis Grace LLC · San Angelo, TXBuilt 1973 · S/N 15074621 N7191SBuchanan Kenneth W · Yucca Valley, CABuilt 1976 · S/N 18265079 N7191TLawson Isaiah · Roswell, NMBuilt 1959 · S/N 46791 N7191XMiller William D · Blacksburg, VABuilt 1961 · S/N 15059291 N71924Keystone Aerial Surveys Inc · Philadelphia, PABuilt 1968 · S/N U206-1226 N7192EBailey Jackson Thomas · Willow Springs, MOS/N 52192 N7192QMansfield Heliflight Inc · Milton, VTBuilt 1972 · S/N 17260492 N7193EErickson Kirk E · Lake Havasu City, AZBuilt 1959 · S/N 52193 N7193TJones Wade T · Wichita, KSBuilt 1959 · S/N 46793 N7193XRound Engine Aero · Nashville, MIS/N 15059293 N7194Ajayi Samuel O · Fredericksburg, VAS/N 15063922 N7194AGuillermo A Pliego M · Corpus Christi, TXS/N 29294 N7194GAvco Patrol LLC · Lyndon, KSBuilt 1969 · S/N 17258894 N7194QOzarks Auto Show Inc · Hollister, MOBuilt 1973 · S/N 17260494 N7194THall William A · Puyallup, WAS/N 46794 N7195FAustin Richard K · Ludington, MIBuilt 1966 · S/N 15063795 N7195GBurnside George C II · Hattiesburg, MSBuilt 1969 · S/N 17258895 N7195MFussy Bernie P · Bowlus, MNBuilt 1958 · S/N 55495 N7195QPuget Sound Flyers · Everett, WABuilt 1972 · S/N 17260495 N7195ST-Square Flights LLC · Tallahassee, FLBuilt 1976 · S/N 18265080 N71967Lipan Creek Flying Service LLC · Eola, TXBuilt 1969 · S/N U206-1241 N7196AL-Bird LLC · Hood River, ORBuilt 1956 · S/N 29296 N7196EMile High Aviation LLC · Pahrump, NVBuilt 1959 · S/N 52196 N7196FStarr Benjamin M · Somerset, OHBuilt 1966 · S/N 15063796 N7196QBurdis W J · Beaver Falls, PABuilt 1972 · S/N 17260496 N7196SSale Reported · Taylorsville, MSSale reportedS/N 15067896 N7197GFly Wissota LLC · Chippewa Falls, WIBuilt 1969 · S/N 17258897 N7197MKansas Soaring Association · Wichita, KSBuilt 1958 · S/N 55497 N7197TNelson Jim · Midlothian, TXS/N 46797 N7198EAcute Holdings LLC · Jenks, OKBuilt 1959 · S/N 52198 N7198FCessna Flyers LLC · Bountiful, UTBuilt 1966 · S/N 15063798 N7198GJones Lawrence A · St Simons Island, GABuilt 1969 · S/N 17258898 N7198QBay Lux Ventures LLC · Tampa, FLBuilt 1972 · S/N 17260498 N7198XScott Allexus D · Melbourne, ARBuilt 1961 · S/N 15059298 N71991Bush-Tell Inc · Aniak, AKBuilt 1968 · S/N U206-1247 N71994Skydive Buckeye LLC · Goodyear, AZBuilt 1968 · S/N U206-1249 N7199EHornor Kent A · Oak Creek, COBuilt 1959 · S/N 52199 N7199FSale Reported · Pikeville, TNSale reportedBuilt 1966 · S/N 15063799 N7199XGrand Aviation LLC · Celina, OHBuilt 1961 · S/N 15059299 N719AWUnrau Wilbur D Trustee · Wolf Point, MTBuilt 1973 · S/N 18262249

Back to AD 87-20-03 R2