Registered aircraft · 1,267

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:88-21-07-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:88-21-07-R1') 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:88-21-07-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:88-21-07-R1')
  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:88-21-07-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:88-21-07-R1')
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.

N153WBOster Dale E · Trego, MTBuilt 1966 · S/N 27-3329 N155EPGogoplex LLC · Wilmington, DEBuilt 1969 · S/N 27-4430 N1577RGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1981 · S/N 278154026 N158GEarle Norman R · Fairview, NCS/N 23-1521 N159BOppold Robert S · Overland Park, KSBuilt 1977 · S/N 27-7754047 N159RSTechnical Education Services Inc · Virginia Beach, VAS/N 27-2817 N15FGShannon Jesse Lee · Boise City, OKBuilt 1975 · S/N 27-7554112 N15JEPremier Flight Center LLC · Hartford, CTBuilt 1964 · S/N 27-2494 N15KYMcdougle Sean · Oklahoma City, OKBuilt 1965 · S/N 27-2780 N15REGreat Alaskan Flooring Inc · Kodiak, AKBuilt 1968 · S/N 27-4068 N15YPDepartamento De Educacion Prami · San Juan, PRBuilt 1968 · S/N 27-3966 N160DBAguilar Theodore · Bozeman, MTBuilt 1959 · S/N 23-1670 N161MRVictor Aircraft Co · Wilmington, DEBuilt 1977 · S/N 27-7754106 N1707TMoore Merritt T II · Silver Creek, NYBuilt 1955 · S/N 23-299 N170TAKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1975 · S/N 27-7654005 N1715YPacific Fleet Aviation LLC · Rochester, NYBuilt 1976 · S/N 27-7654096 N177Executive Travel Authority LLC · Wilmington, DEBuilt 1970 · S/N 27-4511 N178GPanhandle Groundwater Conservation District · White Deer, TXBuilt 1980 · S/N 27-8054028 N178MSouth Texas Weather Modification Association · Pleasanton, TXBuilt 1979 · S/N 27-7954028 N17AFRolle Caraine A · Cypress, TXBuilt 1973 · S/N 27-7405291 N17AKFrancis Joseph · Kure Beach, NCBuilt 1978 · S/N 27-7854103 N17FWhiteside Andrew A · Essexville, MIBuilt 1954 · S/N 23-119 N17WEMckinney Joe M · Tuscumbia, ALBuilt 1978 · S/N 27-7854118 N18269International Aviation Group LLC · Lake Wales, FLBuilt 1959 · S/N 23-1705 N184DGMartin Vicente Eduardo Misa · Miami, FLBuilt 1964 · S/N 27-2504 N186SLJls Property Holdings LLC · Athens, TXS/N 23-236 N18MWRed State LLC · Daytona Beach, FLBuilt 1967 · S/N 27-3691 N18RJDocs Air LLC · Diamondville, WYS/N 27-4382 N1946DArctic Barnabas Ministries · Kenai, AKS/N 27-8054015 N194MLGofly Trading LLC · Opa Locka, FLBuilt 1979 · S/N 27-7954081 N196DBBe Right Back Aviation LLC · Boca Raton, FLBuilt 1973 · S/N 27-7405273 N19KCGrays Bay LLC · Warrenton, ORBuilt 1970 · S/N 274516 N1GLSmith Alfred N D IV · Lake Wylie, SCBuilt 1967 · S/N 27-3826 N1SRRensberger Scott C · Lake Jackson, TXBuilt 1962 · S/N 27-2050 N1SYPacific Fleet Aviation LLC · Rochester, NYS/N 27-7654186 N2007P2007 Papa LLC · Fayetteville, GABuilt 1956 · S/N 23-579 N200DFLijack World Enterprises LLC · Winter Haven, FLS/N 27-4080 N2018PHauer Clifford Joseph Jr · Woodstock, GABuilt 1956 · S/N 23-590 N201NKHelms John Broward II · Bartow, FLBuilt 1972 · S/N 27-4816 N2033PAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 23-608 N2037PKuklo Robert M · Livermore, CABuilt 1956 · S/N 23-614 N203DMCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1966 · S/N 27-3461 N204SCGyure Ronald J · Fort Worth, TXBuilt 1965 · S/N 27-2796 N2050PDzvonik Eugen · Murray, UTBuilt 1956 · S/N 23-634 N20540Baum Martin L · Bullard, TXS/N 27-4193 N2071PAviation Business Corp · Saint Louis, MOBuilt 1956 · S/N 23-658 N2084PSchalk Bretta J · Fountain Run, KYBuilt 1956 · S/N 23-672 N208SEJohn Stuart LLC · Miramar, FLS/N 27-4542 N2090American Valet Air Inc · Wilmington, DEBuilt 1981 · S/N 27-8154010 N2095PForbes Richard L · Plano, TXBuilt 1956 · S/N 23-683

Back to AD 88-21-07 R1