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.

N8763QArtic Backcountry Flying Service LLC · Kotzebue, AKBuilt 1976 · S/N U20603516 N8763SClinton Richard C · Fair Oaks, CAS/N 15062063 N8763XRegistered aircraftBuilt 1961 · S/N 18253163 N8763ZMacdonald John R · Vancouver, WABuilt 1968 · S/N P206-0563 N8764GStrait Media LLC · Anchorage, AKS/N 15062864 N8764XAdventist World Aviation · Wilson, NCBuilt 1961 · S/N 18253164 N8765URebel Metals LLC · Croydon, NHBuilt 1976 · S/N 15077983 N8766GGascho Wendell M · Bridgewater, VABuilt 1966 · S/N 15062866 N8766XFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVBuilt 1960 · S/N 18253166 N8767TReppond Richard · Sage, ARBuilt 1960 · S/N 52667 N8767XSmith Todd A · Duchesne, UTBuilt 1960 · S/N 18253167 N87687Dittmer Dean C · Bennett, COBuilt 1967 · S/N R172-0248 N8768MRegistered aircraftBuilt 1976 · S/N 18264636 N8768RBaker Scott R · Arroyo Grande, CABuilt 1968 · S/N 18258978 N8768TCarter Douglas A · Tower, MNBuilt 1960 · S/N 52668 N8768UWright Roland P · Detroit, MIBuilt 1965 · S/N 17252672 N8768XBeachy Phil · Bonners Ferry, IDBuilt 1960 · S/N 18253168 N8769GHeli Thrills LLC · Wills Point, TXBuilt 1966 · S/N 15062869 N8769TCopper River Airmotive LLC · Copper Center, AKBuilt 1960 · S/N 52669 N8769XOmega I Corp Inc · Middletown, DEBuilt 1961 · S/N 18253169 N8769ZFox Stanton C · Fairfax, VABuilt 1978 · S/N 177RG1358 N876CGGreen Carlton · Carmel Valley, CABuilt 1962 · S/N 18253734 N876R76r Holdings LLC · Rockport, TXBuilt 1978 · S/N 21062844 N876SPb Limited LLC · Kalispell, MTBuilt 1957 · S/N 34356 N876SHPatton Michael D · Tygh Valley, ORBuilt 1958 · S/N 50325 N876SMNathan Smith Ministries · Belmont, NCS/N 18265957 N876WFries Jeffery A · Paw Paw, MIBuilt 1965 · S/N 17253293 N8770TNoble Aviators Inc · Kendallville, INBuilt 1960 · S/N 52670 N8770XRegistration Pending · Tulsa, OKRegistration pending, pending cancellationBuilt 1961 · S/N 18253170 N8771SGillette Robin A · Scio, ORS/N 15062071 N8771XAgainst The Wind Inc · Jasper, TNBuilt 1961 · S/N 18253171 N8772SMccormick Joel S · Elmwood, ILBuilt 1965 · S/N 15062072 N8772XSargent Leslie K · Chuckey, TNBuilt 1960 · S/N 18253172 N8773GWhite Jules W · Wichita, KSBuilt 1966 · S/N 15062873 N8773URegistration Pending · Scotch Plains, NJRegistration pendingBuilt 1965 · S/N 17252677 N8773ZPolhamus Mark Trustee · Thompson Falls, MTBuilt 1969 · S/N P206-0573 N8774ZAero Squadron LLC · San Diego, CABuilt 1969 · S/N P206-0574 N8775BGauger Cody · Edmond, OKBuilt 1957 · S/N 36475 N8775XJust Jump Skydiving LLC · Laurens, NYBuilt 1961 · S/N 18253175 N8775ZB&B Auto Body LLC · Terreton, IDS/N P206-0575 N87767Usda Forest Service Fepp · Malvern, ARBuilt 1967 · S/N R1720105 N8776QRichardson Thomas R · Valleyford, WABuilt 1979 · S/N 18503771 N8777BBurks Danny E · Fordland, MOBuilt 1957 · S/N 36477 N8778BJohnson Timothy L · Berlin, WIBuilt 1958 · S/N 36478 N8778TLogan Ronald Thomas Jr · Newfoundland, PABuilt 1960 · S/N 52678 N8778UWright Penny L · San Francisco, CAS/N 15077986 N8778ZMartin Seth E · Palmyra, PABuilt 1978 · S/N 177RG1362 N8779BMeyers Jess H · Las Vegas, NVBuilt 1957 · S/N 36479 N8779GEga Aero Specialty Services LLC · Beaufort, SCBuilt 1966 · S/N 15062879 N8779TSkyair Express LLC · Overton, NVBuilt 1960 · S/N 52679

Back to AD 87-20-03 R2