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.

N3231LColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1967 · S/N 17256131 N3231TGouse Frederick Earl II · Waxahachie, TXBuilt 1967 · S/N 17700531 N3231VDariz Natascha Y · Mount Laurel, NJFirst renewal noticeBuilt 1974 · S/N 15076431 N3232AKnutson Daniel T · Lodi, WIBuilt 1953 · S/N 25876 N3232DZucchero David M · Stanwood, WABuilt 1954 · S/N 32030 N3232XBitikofer Brent E · Kansas City, KSBuilt 1966 · S/N 15064632 N3232YWise Frederick W · Windsor, PABuilt 1962 · S/N 18254232 N32331Sowers Richard M · Reno, NVBuilt 1980 · S/N 21064188 N3233AWalser Kyle · Midwest City, OKBuilt 1953 · S/N 25877 N3233SVan Ness James A · Buckley, WABuilt 1964 · S/N 18255733 N3233XNollau Gregory P · Big Bear City, CABuilt 1966 · S/N 15064633 N3233YShepperson Ranch Co · Midwest, WYBuilt 1962 · S/N 18254233 N3234ARobold Andrew D · Redmond, ORBuilt 1953 · S/N 25878 N3234YGrefsrud Travis · Pelican Rapids, MNBuilt 1962 · S/N 18254234 N3235SPollard Brent H · Wilburton, OKBuilt 1964 · S/N 18255735 N3236ALibby Stephen Trustee · Anchorage, AKBuilt 1953 · S/N 25880 N3236DFrey Joseph · Fallon, NVBuilt 1955 · S/N 32034 N3236JWoehler Keith A · Bardstown, KYBuilt 1966 · S/N 15065936 N3236LMartin Alan K · Tenaha, TXBuilt 1967 · S/N 17256136 N3236MManning Daniel E · Posen, MIS/N 15059532 N3236UHetrick Daniel R · Orovada, NVBuilt 1963 · S/N 18254636 N3236XBentch James R · Lincoln, MOBuilt 1966 · S/N 15064636 N3237LKeith Investments LLC · Verona, MSBuilt 1967 · S/N 17256137 N3237VTreetop Flying Circus LLC · Niceville, FLBuilt 1974 · S/N 15076434 N3237XRobinson Michael D · Folkston, GABuilt 1966 · S/N 15064637 N3237YCopper Mountain Assets · Winthrop, WABuilt 1962 · S/N 18254237 N3238DLutes Richard L · Hampshire, ILBuilt 1955 · S/N 32036 N3238ESwiss Jack S · Anchorage, AKBuilt 1978 · S/N 17271477 N3238JHolladay Harold · Lamesa, TXS/N 15065938 N3238XHorsager Phillip C · Montevideo, MNBuilt 1966 · S/N 15064638 N3239DJaj Flying LLC · Sutton, NEBuilt 1955 · S/N 32037 N3239ELeaf Air LLC · Queensbury, NYBuilt 1978 · S/N 17271478 N3239LGame Composites Flying Club · Bentonville, ARBuilt 1967 · S/N 17256139 N3239UJohnson Colten T · Richards, MOBuilt 1963 · S/N 18254639 N3239VMccue Michael R · Missoula, MTBuilt 1977 · S/N R1722243 N3239YHarper Mark A · Winston Salem, NCBuilt 1962 · S/N 18254239 N323ACKing Ag Leasing Inc · Sudan, TXBuilt 1967 · S/N 18258024 N323DASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1982 · S/N 21064753 N323DCFlymax Aircraft LLC · Ball Ground, GAS/N P21000384 N323FSFredericks Hall Aviation LLC · Mineral, VABuilt 1986 · S/N 17276547 N323KWBlue Cedar Aviation LLC · Raymore, MOBuilt 1985 · S/N 18268480 N323LULetourneau University · Longview, TXBuilt 1968 · S/N 15068776 N323PCTriego Inc · Dumas, TXBuilt 1979 · S/N R18201235 N323SMAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260679 N323TJGuardian Wings LLC · Fredericksburg, VABuilt 1983 · S/N T30300243 N323TSKnippen Ronald M · Fort Jennings, OHBuilt 1982 · S/N 18268154 N3240LWooden Alan L · Signal Mountain, TNBuilt 1967 · S/N 17256140 N3240SBenson Richard T · Bend, ORBuilt 1964 · S/N 18255740 N3240TFrena John A · Pittsburgh, PABuilt 1967 · S/N 17700540 N3240VAbston Alexandria P · Vancouver, WABuilt 1974 · S/N 15076436

Back to AD 87-20-03 R2