Registered aircraft · 54,017

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.

N5346NMustang Manufacturing Inc · Carson City, NVBuilt 1980 · S/N 18267658 N5346QCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1972 · S/N 15073246 N5346TTiffany Shawn M · Herington, KSBuilt 1964 · S/N 17251246 N5346VRegistered aircraftBuilt 1980 · S/N 172RG0510 N53475Rw Aviation LLC · Fishers, INBuilt 1975 · S/N 33701649 N5347HMonterey Bay Aviation Inc · Watsonville, CABuilt 1975 · S/N 17265410 N5348BBowers Curt E · Jennings, LABuilt 1979 · S/N 15283844 N5348DSwaz Aviation LLC · Mesa, AZBuilt 1979 · S/N 17272536 N5348UC3 Shadow LLC · Columbus, OHBuilt 1984 · S/N 21064874 N5348VKavon Clinreg LLC · Palm Beach Gardens, FLBuilt 1980 · S/N 172RG0511 N5348YWheeler Robert T · Silt, COBuilt 1980 · S/N 21064176 N53491Crossbrook LLC · Willoughby, OHBuilt 1981 · S/N 17274764 N53494Gandarillas Andrew J · Toledo, WABuilt 1981 · S/N 17274765 N5349DFisher Randall A · Salem, OHBuilt 1979 · S/N 17272537 N5349RTroya Aviation LLC · Utica, NYBuilt 1965 · S/N 17252878 N534DWValiair Ltd Co Trustee · Casper, WYBuilt 1976 · S/N 177RG1004 N534FLeiser Harry W · Rome, PABuilt 1965 · S/N T210-0109 N534PCSutton Brad · Vallecito, CABuilt 1975 · S/N 18264394 N53504Aviation Adventures LLC · Hansen, IDBuilt 1975 · S/N 33701664 N53507Flight School Of Gwinnett · Lawrenceville, GABuilt 1981 · S/N 17274769 N5350KCenterline Aviation LLC · Oklahoma City, OKBuilt 1980 · S/N 17274076 N5350MNewsom Bearden And Cobb Inc DBA · Lubbock, TXBuilt 1980 · S/N 15284553 N5350PChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 15284924 N5350RNorth Fergus Flying Club · Winifred, MTBuilt 1965 · S/N 17252879 N5350SSilver Tree LLC · Southern Pines, NCS/N R18201551 N53510Joey Os LLC · Darlington, PABuilt 1975 · S/N 33701670 N53519Gic Inc · Oneill, NEBuilt 1975 · S/N 33701677 N5351DSplan David L · Mccall, IDS/N 50249 N5351HHayes Jeffery M · Yatesville, GABuilt 1975 · S/N 17265411 N5351LHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284298 N5351PPointair Aviation Inc · Port Jeff Sta, NYS/N 15284925 N5351QBarrett Dannie P · Halfway, ORS/N 17261778 N5351VHarris Adam K · Shrewsbury, MABuilt 1977 · S/N R1722292 N53520Harben Grover S III · Gainesville, GAS/N 33701678 N53525Dewind Helicopter LLC · Zeeland, MIBuilt 1976 · S/N 33701682 N5352KPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1980 · S/N 17274077 N5352NAhrens Douglas T · Los Altos, CABuilt 1980 · S/N 18267662 N5352RProam Flyers Of Union County · Matthews, NCBuilt 1965 · S/N 17252882 N5352SGustafson Steven R · Jamestown, NYBuilt 1966 · S/N 337-0452 N5352TFord Howard J · Salt Lake City, UTBuilt 1964 · S/N 17251252 N53531Hayes Inc · Betsy Layne, KYBuilt 1976 · S/N 33701686 N5353DMcmahan Charles B · Gakona, AKS/N 50242 N5353HDe Nunzio Arnold J · Ballard, CABuilt 1979 · S/N 15284090 N5353KCentury Air Inc · Fairfield, NJBuilt 1980 · S/N 17274078 N5353QRegistered aircraftBuilt 1972 · S/N 15073253 N5353SBressler Lewis S · Simi Valley, CABuilt 1966 · S/N 337-0453 N5353TRegistration Pending · Covington, GARegistration pendingBuilt 1964 · S/N 17251253 N53540Orlando Aero Club Inc · Orlando, FLBuilt 1981 · S/N 17274776 N53541Ps N53541 LLC · Green Bay, WIBuilt 1981 · S/N 17274777 N5354BN5354b LLC · Manhattan, MTBuilt 1956 · S/N 33354

Back to AD 87-20-03 R2