Registered aircraft · 54,019

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.

N2509KHolcomb John R · Siloam Springs, ARBuilt 1978 · S/N 18052962 N2509LSchufeldt Lawrence H · North Platte, NEBuilt 1966 · S/N 17255709 N2509USnyder Mari A · Brighton, COBuilt 1963 · S/N 17250109 N2509VBrown James · Georgetown, MEBuilt 1948 · S/N 18012 N2509YAgha-Khan Sikander B · Carolina Shores, NCBuilt 1962 · S/N 17249809 N250CW250 Charlie Whiskey LLC · Topeka, KSBuilt 1982 · S/N 18268273 N250FBishop Thomas W · Decatur, TXBuilt 1959 · S/N 52184 N250GCCarroll James E Trustee · Newington, NHBuilt 1977 · S/N 18266130 N250KBodrero Roger Jay · Outlook, WABuilt 1952 · S/N 20659 N250LMenefee Scott A · Los Banos, CABuilt 1979 · S/N R18200936 N250RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266043 N2511798x LLC · Caddo Mills, TXBuilt 1970 · S/N 17259514 N2511DDfs2024 LLC · Edwards, COBuilt 1979 · S/N 18266873 N2511LDmcflight LLC · Boynton Beach, FLS/N 17255711 N2511RDickey Mark D · Pendleton, ORS/N 18258211 N2511VSutton Aircraft Salvage LLC · Palmer, AKBuilt 1948 · S/N 18014 N2512GSutton Aircraft Salvage LLC · Palmer, AKBuilt 1959 · S/N 51812 N2512JHaller David Henry Trustee · Grover Beach, CABuilt 1964 · S/N 15061012 N2512QPeacock Jeffery D · Cleburne, TXS/N 18257712 N2512SCorsentino Joseph · Temple, TXRegistration revokedBuilt 1967 · S/N 337-0812 N2512UNative Sons Aviation LLC · Lake Placid, FLBuilt 1963 · S/N 17250112 N2512VNichol Nathan P · Anchorage, AKS/N 18020 N2513DPetite Randall L · Lake Tapps, WABuilt 1952 · S/N 20665 N2513GSedlickas Mark A · Graham, WABuilt 1959 · S/N 51813 N2513JT3 Flight Time Building LLC · Richmond Hill, GAS/N 15061013 N2513KCarlson Thomas G · Anchorage, AKBuilt 1978 · S/N 18052964 N2513LDahlberg James C · Ogilvie, MNBuilt 1966 · S/N 17255713 N2513VMcrobie Roger L · Maryville, TNBuilt 1948 · S/N 18016 N2513XChristenson Cole R · West Fargo, NDBuilt 1964 · S/N P206-0013 N2513YWilson Hubert Ernest · Gustavus, AKBuilt 1962 · S/N 17249813 N2514CPayne Jonathan R · Montgomery, ALBuilt 1954 · S/N 26158 N2514DWeindel Victoria E · Anchorage, AKBuilt 1952 · S/N 20666 N2514LRegistration Pending · Macclenny, FLRegistration pendingS/N 17255714 N2514RRichmond Patrick A · Glenmora, LABuilt 1967 · S/N 18258214 N2514UHenson David C · Fort Worth, TXBuilt 1963 · S/N 17250114 N2514XAdair Larry K Trustee · Cameron Park, CABuilt 1964 · S/N P206-0014 N2514YBargabos Julie A · Peterboro, NYBuilt 1962 · S/N 17249814 N2515CCorbett Derek B · Durham, NCBuilt 1953 · S/N 26159 N2515DCooper Gerald W · Kennewick, WABuilt 1952 · S/N 20667 N2515JStockweather Eric A · Normal, ILBuilt 1964 · S/N 15061015 N2515LClear Air Aviation LLC · Talkeetna, AKBuilt 1966 · S/N 17255715 N2515VBoyd Robert T · Quakertown, PABuilt 1948 · S/N 18018 N2516LFlores E Alex · Missouri City, TXBuilt 1966 · S/N 17255716 N2516ULofton Johnathan V · Springer, OKBuilt 1963 · S/N 17250116 N2516VGreat Adventure Sailing Vessell LLC · Greer, SCBuilt 1974 · S/N 177RG0601 N2516YSchutjer Dennis · Clear Lake, IABuilt 1962 · S/N 17249816 N2517JRegistered aircraftBuilt 1964 · S/N 15061017 N2517LCarroll Mark E · Nicholasville, KYBuilt 1966 · S/N 17255717 N2517YEbnet Joel · Holdingford, MNBuilt 1962 · S/N 17249817 N2517ZGerrety Loren P · Anchorage, AKBuilt 1962 · S/N 185-0517

Back to AD 87-20-03 R2