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.

N6139BFelker Gary L · Odessa, TXBuilt 1973 · S/N 210-59909 N6139EWarner Aviation LLC · Belding, MIBuilt 1958 · S/N 46239 N6139KKuykendall Justin R · Petaluma, CAFirst renewal noticeBuilt 1975 · S/N 15077547 N6139MKelly David M · Issaquah, WAFirst renewal noticeBuilt 1980 · S/N 15284630 N6139TGrad Jonathan P · Warroad, MNS/N 15060839 N613AKNorman Scott E · Anchorage, AKBuilt 1976 · S/N 18265221 N613TLSams Aircraft LLC · Fredonia, KYBuilt 1980 · S/N 18267613 N613WCAmpaire Inc · Hawthorne, CABuilt 1966 · S/N 337-0372 N613WDCruse Josiah L · Rainier, ORBuilt 1969 · S/N 18259805 N613YHKuspuk School District · Aniak, AKBuilt 1980 · S/N 20700633 N61405Rovey George A · Cove, ORBuilt 1980 · S/N 18504174 N6140EIorio Jeffrey M · Tucson, AZBuilt 1958 · S/N 46240 N6140FFluno John I · San Rafael, CAS/N A1500425 N6140GSmoketown Flight Center LLC · Smoketown, PABuilt 1969 · S/N 15071640 N6140KHepner Glenn L · New Port Richey, FLBuilt 1980 · S/N 17274169 N6141BPayne Jacqueline · Minden, NVBuilt 1957 · S/N 34141 N6141EAbpz LLC · Mc Veytown, PABuilt 1958 · S/N 46241 N6141TMilligan David L · Fresno, CAFirst renewal noticeBuilt 1982 · S/N R18201918 N61423State Of Utah · Salt Lake City, UTBuilt 1980 · S/N 18504180 N6142EHabecker David A · Tecumseh, MIBuilt 1958 · S/N 46242 N6142KCreamer Ryan Patrick · Tower Hill, ILBuilt 1975 · S/N 15077550 N6142TMiller Timothy A · Opheim, MTBuilt 1964 · S/N 15060842 N6142XHurt Ronald L · Smithville, TNBuilt 1977 · S/N 17269169 N61438Peot James J · Woodinville, WABuilt 1980 · S/N 18504189 N6143BRushing Harley J III · Cheraw, SCBuilt 1957 · S/N 34143 N6143GSale Reported · Brodhead, WISale reportedBuilt 1969 · S/N 15071643 N6143QSt Onge Andre E · Hooksett, NHBuilt 1981 · S/N 15285166 N6143TWong Antonio L · Santa Rosa, CAS/N R18201919 N61441Cook Sterling S · Wasilla, AKBuilt 1980 · S/N 18504191 N6144BRieser Robert · Aurora, ILBuilt 1957 · S/N 34144 N6144EBlack Kenneth Cory · Chillicothe, OHBuilt 1958 · S/N 46244 N6144GHoke Christopher R · Kernersville, NCS/N 15071644 N6144LArtz Agri Sales LLC · Westhope, NDBuilt 1980 · S/N 15284364 N6145ESaylor Willa G · Newburg, PAS/N 46245 N6145FAlpha Bravo Aviation LLC · Trophy Club, TXBuilt 1973 · S/N A1500426 N6145SPlaney Mcplane Face LLC · N Richlnd Hls, TXBuilt 1980 · S/N R18201625 N6145TJones Blake · Selma, ALBuilt 1964 · S/N 15060845 N6146BMiles From Ordinary LLC · Auburn, WAS/N 34146 N6146EDahlberg James C · Ogilvie, MNBuilt 1958 · S/N 46246 N6146FHeppner Sebastian · Fishers, INS/N A1500427 N6146QWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1981 · S/N 15285169 N6146TDanyal David · Lake Stevens, WABuilt 1964 · S/N 15060846 N61471N484rf LLC · Jackman, MES/N 18504202 N61473U S Department Of Interior · Boise, IDBuilt 1981 · S/N 18504204 N6147BMock David J · Mesa, AZS/N 34147 N6147FHenry Charles C · Portland, TNBuilt 1968 · S/N 21059047 N6147RBloom James F · Clay City, KYS/N 172RG0094 N6147TBooks Clifton B · Harrah, OKBuilt 1964 · S/N 15060847 N6148EPlant Robert L · Churubusco, INBuilt 1958 · S/N 46248 N6148FWorsham Eric S · La Porte, TXS/N 21059048

Back to AD 87-20-03 R2