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.

N3211EApm Leasing LLC · Casper, WYBuilt 1978 · S/N 17271470 N3211JGo Captain LLC · Lake Worth, FLBuilt 1966 · S/N 15065911 N3211SNoble Tom R · Winnsboro, TXBuilt 1964 · S/N 18255711 N3211YFour M Properties LLC · Prague, OKBuilt 1962 · S/N 18254211 N3212JBrown Joseph E · Palmdale, CABuilt 1966 · S/N 15065912 N3212LBlackstone Rotorcraft Inc · Hartselle, ALBuilt 1967 · S/N 17256112 N3212TRichmond Timothy R · Deland, FLBuilt 1967 · S/N 17700512 N3213SRosengrants Matthew R · Walsh, COBuilt 1964 · S/N 18255713 N3213XAlrubaiie Ihssan R · Fort Worth, TXBuilt 1966 · S/N 15064613 N3213YFletcher Jerry D · Yukon, OKBuilt 1962 · S/N 18254213 N3214TJohnson Hugh S · Rochester, NYBuilt 1967 · S/N 17700514 N3214UBibus Michael A · Austin, MNBuilt 1963 · S/N 18254614 N3215AHoffmeyer Scott D · Carson City, NVBuilt 1953 · S/N 25859 N3215TMcgee Debra L · Tuscola, TXBuilt 1967 · S/N 17700515 N3215XVoltmer Benjamin P · Excelsior Springs, MOBuilt 1966 · S/N 15064615 N3216EChrabot Gerard S · Virginia Beach, VABuilt 1978 · S/N 17271471 N3216TWss Aviation Inc · Jerseyville, ILBuilt 1967 · S/N 17700516 N3216VTwo Dot Aircraft LLC · Kalispell, MTBuilt 1974 · S/N 15076424 N3217JMalinchak Louis Trustee · Bristow, OKBuilt 1966 · S/N 15065917 N3217SGrotbeck Christopher L · Albuquerque, NMBuilt 1964 · S/N 18255717 N3217UWelkin Aero Inc · Garden Plain, KSBuilt 1975 · S/N 18502738 N3217YBrowne Robin P · Dallas, TXBuilt 1962 · S/N 18254217 N3218DWright James Cope · Round Rock, TXBuilt 1955 · S/N 32016 N3218JKanooth Steven L · Washougal, WABuilt 1966 · S/N 15065918 N3218KSteinhausen Darrell · Torrington, WYBuilt 1967 · S/N 15065356 N3218TShepherd Darren · Shepherdsville, KYBuilt 1967 · S/N 17700518 N3218URadford Tara Lynn · Elmira Heights, NYBuilt 1963 · S/N 18254618 N3218YCollins Marcus E Jr · Camilla, GABuilt 1962 · S/N 18254218 N3219LBlock Taylor I · Sibley, IAS/N 17256119 N3219SYogodzinkski Steve M · Amberson, PAS/N 18255719 N321ALFincher William T · Chandler, AZBuilt 1976 · S/N 17268353 N321AYCameron Kari L · Ashland, ORBuilt 1973 · S/N 18261756 N321BLWalls Bruce · Middletown, OHBuilt 1981 · S/N P21000792 N321BMMacintosh William J · Simpsonville, SCBuilt 1966 · S/N 17254361 N321BPCenturion Air Inc · Ridgewood, NJS/N 21063986 N321BSBrown Gregory N Trustee · Flagstaff, AZBuilt 1978 · S/N 18266765 N321CHSmith James Christian · Rockport, TXBuilt 1962 · S/N 21058061 N321DGAdkison Edy P · Riverside, CABuilt 1969 · S/N 21059201 N321EEVermont Skydiving Adventures Inc · Addison, VTBuilt 1956 · S/N 33582 N321JPAzure Skyes Holdings LLC · Poulsbo, WABuilt 1980 · S/N 18504166 N321KBBecker Kevin P · Orange, CABuilt 1977 · S/N 33701782 N321KKPanoche Aviation Co LLC · Fresno, CABuilt 1979 · S/N 18267488 N321KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1982 · S/N 17275853 N321LGLaughing Gull Aviation Inc · Fort Lauderdale, FLBuilt 1978 · S/N 21062769 N321MMJohnson Curtis A · St Paul, MNBuilt 1979 · S/N 18503976 N321PAFosston Flying Club Inc · Fosston, MNBuilt 1971 · S/N 17260202 N321PCStene Aviation Inc · Polson, MTS/N 21062813 N321PPMathews Aviation LLC · Marysville, CABuilt 1977 · S/N 18265834 N321QPelco Aviation Inc · Hampton Bays, NYBuilt 1978 · S/N R18200438 N321RBMessmore Micheal Henry · Toledo, WABuilt 1976 · S/N 18052677

Back to AD 87-20-03 R2