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.

N8249GComerford John D Trustee · Saint Louis, MOBuilt 1974 · S/N 18263356 N8249MRancho Bonito LLC · Oxnard, CABuilt 1977 · S/N 21062039 N8249TTolmachev Nikolay A · Anchorage, AKBuilt 1960 · S/N 17556949 N8249UDracka Charles L · Port Clinton, OHS/N 17252149 N8249VSutton Aircraft Salvage LLC · Palmer, AKBuilt 1966 · S/N 18051751 N8249XDish Technologies LLC · Elm City, NCBuilt 1961 · S/N 17248749 N824BABarr Air Patrol LLC · Mesquite, TXBuilt 1979 · S/N 18266788 N824FFly Well Flying Club Inc · Roseville, MNBuilt 1977 · S/N R18200022 N824MAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1981 · S/N P21000763 N824WPPhillips Wayne A Trustee · Cameron Park, CABuilt 1973 · S/N 18262152 N8250ARyan Craig M · Corona Del Mar, CAS/N 25102 N8250BMortenson Daniel R Trustee · Newhall, CABuilt 1957 · S/N 36050 N8250FRyan Good Aviation LLC · Sioux Falls, SDS/N 15064350 N8250LStieler David C · Marlette, MIBuilt 1967 · S/N 17256450 N8250SRegistration Pending · Statesville, NCRegistration pendingBuilt 1965 · S/N 15061850 N8250UCalderon Daniel · Orlando, FLS/N 17252150 N8250XVolk Kenneth Lee · Marshall, TXBuilt 1961 · S/N 17248750 N8251AJulius William C · Julesburg, COS/N 25103 N8251TSkylark 61 LLC · Fair Oaks, CAS/N 17556951 N8251XInman Charles E · Havre, MTBuilt 1961 · S/N 17248751 N8251ZGarner Charlotte Trustee · Sun Lakes, AZBuilt 1963 · S/N 205-0251 N8252ADuane Peters · Anchorage, AKBuilt 1952 · S/N 25104 N8252LSky And Summit Aviation LLC · Suwanee, GABuilt 1967 · S/N 17256452 N8252MApplied Olap Inc · Huntsville, ALBuilt 1969 · S/N 21059252 N8253FSinclair Jerry D · Watonga, OKBuilt 1966 · S/N 15064353 N8253GHudson Allen N · Bowling Green, KYS/N 177RG0153 N8253LKostroski Larry J · Tucson, AZBuilt 1967 · S/N 17256453 N8253MHudak Organization LLC · Cedar Grove, NJBuilt 1969 · S/N 21059253 N8253QTogo Aviation Services LLC · Palmer, AKBuilt 1976 · S/N U20603249 N8253THolzgrove Daniel R · Detroit Lakes, MNBuilt 1960 · S/N 17556953 N8253XMasters Mission · Robbinsville, NCS/N 17248753 N8254ABerna Glen F · Pulaski, WIBuilt 1952 · S/N 25106 N8254LDennard C Alan · Coolidge, GABuilt 1967 · S/N 17256454 N8254QTogo Aviation Services LLC · Palmer, AKBuilt 1970 · S/N U2061479 N8254TBaxter Christopher D · Trimble, MOBuilt 1960 · S/N 17556954 N8254UWolf Nathan · Wishek, NDBuilt 1964 · S/N 17252154 N8254XHd Security Systems Inc · Watertown, TNBuilt 1961 · S/N 17248754 N8255FStarks Aviation Inc · Pittsburgh, PAS/N 15064355 N8255GCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1971 · S/N 177RG0155 N8255LAllen Shaun M · Lake Ann, MIBuilt 1967 · S/N 17256455 N8255QKavik Aviation Services LLC · Palmer, AKBuilt 1975 · S/N U20603116 N8255SConz Gerald Patrick Jr · Wyandotte, MIS/N 15061855 N8255TVan Hoomissen James · Wasilla, AKBuilt 1960 · S/N 17556955 N8255XFeik Robert · North Powder, ORS/N 17248755 N8255ZSonoma County Fliers LLC · Petaluma, CABuilt 1963 · S/N 205-0255 N8256ACharlestream David · Eagle River, AKBuilt 1952 · S/N 25108 N8256BHanes Ronald J · Bowling Green, KYBuilt 1957 · S/N 36056 N8256QRegistered aircraftBuilt 1975 · S/N U20603117 N8256URegistered aircraftBuilt 1964 · S/N 17252156 N8256ZRapozo Martin · Tarpon Springs, FLBuilt 1964 · S/N 205-0256

Back to AD 87-20-03 R2