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.

N7230SMarsh John E · Washington, DCBuilt 1976 · S/N 18265084 N72313Alaskan Air Charter LLC · Anchorage, AKBuilt 1969 · S/N U206-1365 N7231QDsr-Cherokee 180 LLC · Dallas, TXS/N 17260531 N7232ABakunova Eugenia S · Cordova, AKBuilt 1956 · S/N 29332 N7232ESitta Donald C · Farmington, NMBuilt 1959 · S/N 52232 N7232NT&A Farm LLC · Rifle, COBuilt 1974 · S/N 18263023 N72337Gilbert Daniel Keith · Kodiak, AKBuilt 1969 · S/N U206-1374 N7233MGunderson David A · Box Elder, SDBuilt 1958 · S/N 55533 N7233SHeidelberg Haley · Huntington, TXBuilt 1967 · S/N 15067933 N72342Ampaire Inc · Long Beach, CABuilt 1973 · S/N 33701567 N72347Hone Landscape Company LLC · Carnation, WABuilt 1969 · S/N U206-1377 N7234AMoore Thomas K · Pleasant View, UTBuilt 1956 · S/N 29334 N7234GBittenbender Peter E · Grand Rapids, MNFirst renewal noticeBuilt 1970 · S/N 17258934 N7234QLavinio Stephen E · Southampton, NYBuilt 1972 · S/N 17260534 N7235GMcnair William H · Gold Beach, ORBuilt 1970 · S/N 17258935 N7235XSpencer Tanya H · Coolidge, AZBuilt 1961 · S/N 15059335 N72361Innovative Solutions Inc · Edmond, OKBuilt 1973 · S/N 33701568 N7236MWright Steven William · Bend, ORFirst renewal noticeBuilt 1958 · S/N 55536 N7236QTeren Nelson F · Friday Harbor, WABuilt 1972 · S/N 17260536 N7236SJanvrin Jerry M · Buffalo, SDBuilt 1967 · S/N 15067936 N72370Vinland Aerodrome Inc · Baldwin City, KSS/N 33701570 N7237GIvoprop Corp · Long Beach, CABuilt 1970 · S/N 17258937 N7237QMartin Bach Aviation LLC · Cornelius, NCBuilt 1972 · S/N 17260537 N7237SMetcalf Rodney K · Jonesborough, TNS/N 15067937 N7238EStevenson Bill · Sunrise Beach, TXBuilt 1959 · S/N 52238 N7238MHubler Bruce F · Caldwell, IDBuilt 1958 · S/N 55538 N7238NKietzer Rocklyn D · Hartford, MIBuilt 1974 · S/N 18263029 N7238SExecutive Flight Institute LLC · Murrieta, CABuilt 1967 · S/N 15067938 N72395Orion Works Ltd · Denali Park, AKBuilt 1969 · S/N U206-1393 N7239AEasley Daniel W · Wasilla, AKBuilt 1956 · S/N 29339 N7239EEnsey Gary D · Finley, OKS/N 18502642 N7239MPierce Steven P · Towanda, KSBuilt 1958 · S/N 55539 N7239NSea Island Skies LLC · Ponte Vedra Beach, FLS/N 18263030 N723CMOmbra Aria LLC · Dover, DEBuilt 1978 · S/N 15282823 N723CSFinch Dennis G Jr · Long Prairie, MNS/N 18051897 N723DMCaswell & Sons LLC · Belmont, NCBuilt 1977 · S/N 18266076 N723FClear Skies LLC · Stuart, FLBuilt 1983 · S/N U20606714 N723GPuerta Jose Fernando Del Valle · Miami, FLBuilt 1976 · S/N 17268008 N723LAGregg James H · Parkton, NCBuilt 1958 · S/N 36930 N723LCLudwig Robert P · Pflugerville, TXBuilt 1965 · S/N 17253332 N723NETaft Millens W III Trustee · Wilton, CTBuilt 1980 · S/N 18267616 N723SBFreeman-Benson Bjorn N · Portland, ORS/N 17701786 N723SSTomlinson Jason R · Lake Jackson, TXBuilt 1979 · S/N 18267193 N723THSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 15281348 N72403Drury Edward D · Little Silver, NJS/N 33701576 N72406Mercer Don G · Hendersonville, TNBuilt 1973 · S/N 33701577 N7240AIrwin Timothy L · Cottonwood, AZBuilt 1956 · S/N 29340 N7240GKendallville Flying Club Inc · Auburn, INBuilt 1970 · S/N 17258940 N7240XGootee Gregory A · Anchorage, AKS/N 15059340 N72412Intricate Bay Operating LLC · Saylorsburg, PABuilt 1969 · S/N U206-1396

Back to AD 87-20-03 R2