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.

N3148XJennings Dewey S · Springfield, MOBuilt 1966 · S/N 17255298 N3148YHernandez Alfonso C · Garland, TXBuilt 1962 · S/N 18254148 N3149AOlson Karl D · Fairbanks, AKBuilt 1953 · S/N 25793 N3149TShugart Fredrick William · Canfield, OHBuilt 1967 · S/N 17700449 N314ATBerlin Airlift Historical Foundation · Farmingdale, NJBuilt 1968 · S/N 337-1047 N314AVN1412v LLC · Manassas, VABuilt 1974 · S/N 17263557 N314BAComer Jacob · Troy, MOBuilt 1962 · S/N 18254547 N314BWCooper Matthew A · Seattle, WABuilt 1952 · S/N 25389 N314GTYellow Jacket Flying Club Inc · Atlanta, GABuilt 1981 · S/N 17274774 N314MPTeristar LLC · Lewes, DEBuilt 1958 · S/N 51634 N314NFWillis Charlotte Y · Belleview, FLBuilt 1960 · S/N 52548 N314PYKahn William D · Weddington, NCBuilt 1971 · S/N 18260879 N314RSAcorn Mutual Flying Club Inc · Hershey, PABuilt 1977 · S/N 17269038 N314SOrem John Marshall · Shallowater, TXBuilt 1956 · S/N 33981 N314TRShalexco LLC · Salt Lake City, UTBuilt 1979 · S/N R18201086 N314TTSappa Valley Construction LLC · Oberlin, KSBuilt 1961 · S/N 18253457 N3150DTransmountain Aviation Inc · Kasilof, AKBuilt 1955 · S/N 31948 N3150JKeown Kyle W · Saint Charles, MOBuilt 1966 · S/N 15065850 N3151ADavis William G · Mercer, MEBuilt 1953 · S/N 25795 N3151DVan Aero LLC · Dover, DEBuilt 1955 · S/N 31949 N3151EAviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 17271453 N3151FBentley Nicholas Klausing · Reading, PABuilt 1966 · S/N 18257251 N3151JStava Robert D · Brainard, NEBuilt 1980 · S/N T18803609T N3151QRairdan Todd G · Vacaville, CABuilt 1967 · S/N 18258151 N3151SThomas Darryl · Belfield, NDBuilt 1964 · S/N 18255651 N3151XJoseph Stern · Sherman, TXS/N 17702399 N3151YVert James E · Davison, MIBuilt 1962 · S/N 18254151 N3152FJk Aviation LLC · Warden, WABuilt 1966 · S/N 18257252 N3152QFff Aviation LLC · Land O Lakes, FLS/N 18258152 N3152SDavis Lee W · Burns, ORFirst renewal noticeBuilt 1964 · S/N 18255652 N3153ALea Robert W · Minter City, MSBuilt 1953 · S/N 25797 N3153BSeverson James A Jr · Tualatin, ORBuilt 1983 · S/N P21000834 N3153CCulver Marc D · Anchorage, AKBuilt 1954 · S/N 30952 N3153DN3153d LLC · Middletown, DEBuilt 1955 · S/N 31951 N3153QMaine Mold & Machine Inc · Hartford, MEBuilt 1967 · S/N 18258153 N3153TRegistered aircraftBuilt 1967 · S/N 17700453 N3154BRegistration Pending · Turner, MTRegistration pending, pending cancellationBuilt 1952 · S/N 25396 N3154CMitchell Barry C · Sagle, IDBuilt 1954 · S/N 30953 N3154DJohnson Daniel P · Pardeeville, WIS/N 31952 N3154RKuchera Ray A · Rockdale, TXBuilt 1967 · S/N 18258554 N3155CNolan Michael William Jr · Silver Spring, MDBuilt 1954 · S/N 30954 N3155DNervino Blake · Turlock, CABuilt 1955 · S/N 31953 N3155FHansen Jeremy · Burlington, COBuilt 1966 · S/N 18257255 N3155QLandro Rebecca · Puyallup, WAS/N 18258155 N3155REnright Matthew R · Skiatook, OKBuilt 1967 · S/N 18258555 N3155TRobbins Charles R · Trout Creek, MTBuilt 1967 · S/N 17700455 N3155VHutchinson Kevin J · Poplar Grove, ILS/N 15076403 N3156ANorth American Aero LLC · Madison, NEBuilt 1953 · S/N 25800 N3156CMarshall Robert L · Pine River, MNBuilt 1954 · S/N 30955 N3156RChamplain Robert F · Canton, ILBuilt 1967 · S/N 18258556

Back to AD 87-20-03 R2