Registered aircraft · 54,015

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.

N6200EKirkpatrick Heather A · Clarkston, MIBuilt 1958 · S/N 46300 N6200RFlycarolina LLC · Charlotte, NCBuilt 1979 · S/N 172RG0112 N6200SKnick Michael J · Camarillo, CABuilt 1967 · S/N 15067000 N6201GOlson Christopher L · Delavan, WIBuilt 1969 · S/N 15071701 N6201THowett Robert L · Pikeville, NCS/N 15060901 N6202BGamache Daniel S · Pleasanton, CABuilt 1978 · S/N 21062706 N6203EBandy Suzanne M · Newport, ORBuilt 1958 · S/N 46303 N6203RCannon Elliot M · Paso Robles, CABuilt 1965 · S/N 15061503 N62049Carlesimo Bernard Vincent · Sea Girt, NJS/N 17275203 N6204PWisto James F · Chandler, AZBuilt 1981 · S/N 15284987 N6204SRed Baron Flying Club Inc · Pleasant Ridge, MIBuilt 1967 · S/N 15067004 N6204TFlory Michael S · Baxley, GABuilt 1964 · S/N 15060904 N62058Sky Warrior Flight Training Inc · Pensacola, FLS/N 17275204 N6205EMcwilliams Michael W · Derby, KSBuilt 1958 · S/N 46305 N6205HCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 18267876 N6205SFriesen Valry C · Ryder, NDBuilt 1967 · S/N 15067005 N6205TOglesby Dale A · Galena, KSBuilt 1983 · S/N R18201933 N6205VRed Baron LLC · Middletown, DEBuilt 1980 · S/N 172RG0590 N6206ANipper James R · Defuniak Springs, FLBuilt 1956 · S/N 33006 N6206DP & W Investments Inc · Wilmington, DEFirst renewal noticeBuilt 1979 · S/N 17272634 N6206RHagan Steve P · Mexico, MOBuilt 1965 · S/N 15061506 N6206SSluyter Zachary W · Greeley, COBuilt 1967 · S/N 15067006 N6207ABtp Inc · Missoula, MTBuilt 1956 · S/N 33007 N6207EDick Charles H · Milton, KSBuilt 1958 · S/N 46307 N6207HYr-Aircraft Leasing LLC · Bethel, AKBuilt 1979 · S/N 20700551 N6207KMoberg Charles W · Edina, MNBuilt 1975 · S/N 15077587 N6207MFranklin Dirk W · Beaumont, TXBuilt 1954 · S/N 30640 N6208EWharton Melissa P · Wise, VABuilt 1958 · S/N 46308 N6208GWilson Tom P · Ontario, CABuilt 1969 · S/N 15071708 N62093American Aircraft Sales Co · Livermore, CAS/N 17275210 N62098Delta State University · Cleveland, MSS/N 17275211 N6209C8 Waters LLC · Goodyear, AZBuilt 1979 · S/N 21063830 N6209EReynolds Richard E · Trumansburg, NYBuilt 1959 · S/N 46309 N6209NZimmerman Dean F · Royalton, MNBuilt 1980 · S/N 18267797 N6209PFly Fast Live Slow LLC · Chiefland, FLBuilt 1978 · S/N P21000151 N6209TGordon Gregory J · Bay Village, OHBuilt 1983 · S/N R18201937 N620GWBoyer Skip P · Oak Harbor, WABuilt 1972 · S/N 17260486 N620MMRahill John G · Burlington, VTBuilt 1957 · S/N 32780 N62104Condor Aero Club Inc · Zelienople, PAS/N 17275213 N6210ADepot Avionics Inc · Alamosa, COBuilt 1956 · S/N 33010 N6210EHodges Darin C · West Jefferson, NCBuilt 1958 · S/N 46310 N6210FLichtman Aaron M · Baltimore, MDBuilt 1975 · S/N 18264123 N6210GJm Pop LLC · Queen Creek, AZBuilt 1969 · S/N 15071710 N6210QNot For Naught LLC · Wimberley, TXBuilt 1981 · S/N 15285195 N6210TVandenakker Greg W · Whitinsville, MABuilt 1983 · S/N R18201938 N62112Southern Sky Aviation LLC · Dover, TNS/N 17275214 N6211ASaulsberry Regor L · Datil, NMBuilt 1956 · S/N 33011 N6211BFleming Patrick J Trustee · Palm Desert, CABuilt 1978 · S/N 21062708 N6211DMcdonald Air Services LLC · Saint Johns, MIBuilt 1979 · S/N 17272638 N6211KCalifornia Management And Consulting LLC · North Hollywood, CABuilt 1975 · S/N 15077588

Back to AD 87-20-03 R2