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.

N3172YPeters Barry S · Montague, CABuilt 1962 · S/N 18254172 N3173BHaynes Stefen L · Homer, AKBuilt 1952 · S/N 25415 N3173CMcgaha Justin L · Hooker, OKS/N 30972 N3173ESkywarrior Flight Training LLC · Pensacola, FLBuilt 1978 · S/N 17271461 N3173FJames Pearl LLC · Norfolk, VABuilt 1966 · S/N 18257273 N3173SCortese Farm And Ranch Inc · Fort Sumner, NMFirst renewal noticeBuilt 1964 · S/N 18255673 N3173XRegistration Pending · Lutz, FLRegistration pendingBuilt 1966 · S/N 15064573 N3174DRegistered aircraftBuilt 1955 · S/N 31972 N3174FRozier Harold H Jr · Blackshear, GABuilt 1966 · S/N 18257274 N3174QMclaughlin Daniel R · Xenia, OHBuilt 1967 · S/N 18258174 N3174UMorris Debbie L · Columbus, GABuilt 1963 · S/N 18254574 N3174XRenner Colton A · Easley, SCBuilt 1966 · S/N 15064574 N3175BSmith Robert J · Easton, PABuilt 1952 · S/N 25417 N3175CClay Jason I · Imperial Beach, CABuilt 1954 · S/N 30974 N3175FEstes Bernard R · Bumpass, VABuilt 1966 · S/N 18257275 N3175JJohnson David J Jr · Yucaipa, CABuilt 1966 · S/N 15065875 N3175UKeller Richard J · Martinsburg, WVBuilt 1963 · S/N 18254575 N3175VDunaire LLC · Mechanicsburg, PABuilt 1974 · S/N 15076408 N3175YPittman Joel C · Apple Valley, CABuilt 1962 · S/N 18254175 N3176AHalbeisen Robert C · Fairbanks, AKBuilt 1953 · S/N 25820 N3176CYoung Thomas O · Battle Ground, WABuilt 1954 · S/N 30975 N3176JAquaero LLC · San Antonio, TXBuilt 1966 · S/N 15065876 N3176XHarless Phillip M · Mcdonough, GAFirst renewal noticeBuilt 1966 · S/N 15064576 N3176YThomas Steven Dale · Monticello, ILS/N 18254176 N3177Duvall John M III · Cincinnati, OHBuilt 1967 · S/N 17700660 N3177CRsb Properties LLC · Lewes, DEBuilt 1978 · S/N R18200248 N3177JDouble Rr Holdings LLC · Dallas, TXS/N 15065877 N3177SFreeman William R · Lenexa, KSBuilt 1964 · S/N 18255677 N3177TCain James W · Big Rapids, MIBuilt 1967 · S/N 17700477 N3177VSmith Daniel P · St George, UTBuilt 1974 · S/N 15076409 N3177XBandy Suzanne M · Newport, ORBuilt 1966 · S/N 15064577 N3177YSkyknights Sport Parachute Club Inc · East Troy, WIFirst renewal noticeBuilt 1962 · S/N 18254177 N3178DSager Kenneth A · Hummelstown, PABuilt 1955 · S/N 31976 N3178JBirmingham Pilot Academy LLC · Birmingham, ALS/N 15065878 N3178TAdvantage Aviation Services LLC · South Saint Paul, MNS/N 17700478 N3178YNiles Air LLC · Concord, NCBuilt 1962 · S/N 18254178 N3179BLevin Lawrence E · North Pole, AKBuilt 1952 · S/N 25421 N3179CWoods Kevin M · Spokane, WABuilt 1954 · S/N 30978 N3179DPreiss James M Trustee · Poplar Grove, ILBuilt 1955 · S/N 31977 N3179FMoran Peter J · Como, MSBuilt 1966 · S/N 18257279 N3179JTri-County Flyers LLC · Morgantown, PABuilt 1966 · S/N 15065879 N3179YWolstein Joe M · Bigfork, MTBuilt 1962 · S/N 18254179 N317ACChickenhawk Inc · Wilmington, MABuilt 1975 · S/N 17265537 N317GTKatz Gary G · Louisville, KYBuilt 1962 · S/N 17249734 N317KAWycka Michelle Sarah · Stayton, ORS/N 18254317 N317KGGouvin Gregory A · West Suffield, CTS/N 25282 N318Liberty University School Of Aeronautics · Lynchburg, VAFirst renewal noticeBuilt 1966 · S/N R172-0006 N31803Mekker Mark S · Getzville, NYS/N 18052420 N3180ARoss Ranch & Livestock Co · Jordan, MTBuilt 1953 · S/N 25824 N3180DKleimer Steve · Bozeman, MTBuilt 1955 · S/N 31978

Back to AD 87-20-03 R2