Registered aircraft · 85,616

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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.

N1095UMalahmeh Adel J · New Iberia, LAS/N 17266844 N1095XVillegas Miguel Angel Cuello · Weston, FLBuilt 1975 · S/N 28R-7535239 N1096KSlocum Eugene A · Bozeman, MTBuilt 1996 · S/N EA-590 N1096TEvans Charles B · Benbrook, TXS/N 28-26284 N1096UBraten Randall O · Cody, WYBuilt 1976 · S/N 17266845 N1097GAos Aviation LLC · Baton Rouge, LAS/N E-3035 N1097MNunes Lindybergh Jr · Laporte, INBuilt 1970 · S/N 17259497 N1097THorizon Aviation LLC · Brooks, GABuilt 1969 · S/N 28-26287 N1097WFred Wacker Agency Inc · Miles City, MTBuilt 1973 · S/N E-426 N1097ZIndian Sky LLC · Bossier City, LABuilt 1997 · S/N E-3083 N1098MBingham John R · Leawood, KSBuilt 1970 · S/N 17259498 N1098UKane Patrick · Chicago, ILBuilt 1976 · S/N 17266847 N1098WB & G Aviation LLC · Virginia Beach, VABuilt 1996 · S/N E-3043 N1099AFritz William · Franklin, PABuilt 1997 · S/N E-3088 N1099CBrooks Jerald W · Anderson, CABuilt 1959 · S/N 1370 N1099FSaal Christopher J · Anchorage, AKFirst renewal noticeBuilt 1975 · S/N 18502754 N1099JLee'S Sea Air Inc · Kiana, AKBuilt 1967 · S/N 32-40274 N1099MSavery Creek Holdings LLC · Dixon, WYS/N EA-591 N1099WTop Hand Inc · Laurel, MTBuilt 1973 · S/N E-424 N109AFD&D Aviation LLC · Weatherford, TXBuilt 1981 · S/N CE-983 N109AKHarris Eric W Jr · Moncks Corner, SCBuilt 1956 · S/N D-4464 N109ATAguillard Robert N · Memphis, TNBuilt 1974 · S/N 32-7540042 N109BABall Edward C II · Valley Center, CABuilt 1992 · S/N CE-1658 N109CCTrans-Caribbean Air Exp & Imp Inc · Miami, FLBuilt 1968 · S/N 27-4024 N109DWAero East USA LLC · Portage, INBuilt 1976 · S/N TJ13 N109EADegiarde Robert P · New York, NYBuilt 1994 · S/N E-2897 N109FCUsda Forest Service Fepp · Tallahassee, FLBuilt 1980 · S/N 31-8012073 N109GPCash Management Consulting LLC · Granite Springs, NYBuilt 1977 · S/N 28-7816287 N109HBadke Paul J · Ray, MIBuilt 1962 · S/N 21057921 N109KBWings Aviation Inc · Valparaiso, INBuilt 1978 · S/N 28R7803043 N109LDEast Bay Flight LLC · Alameda, CABuilt 1979 · S/N 28-7990292 N109LLLewis & Lewis Equipment LLC · Dodge City, KSBuilt 1991 · S/N E-2626 N109MBFirefly Aviation LLC · Midland, TXBuilt 1978 · S/N 32R-7887238 N109MLJerry Luttrell And Associates Inc · Kearney, MOBuilt 1988 · S/N E-2450 N109QShariff Diane · Cameron Park, CABuilt 1966 · S/N D-8126 N109RBClark William R · Anchorage, AKBuilt 1965 · S/N 282612 N109RCLentfer Clinton H A · Anchorage, AKBuilt 1974 · S/N U20602616 N109RFBartley Scott C · Chaska, MNBuilt 1984 · S/N 25-0819 N109RSUnited States Department Of Interior · Boise, IDS/N U20606002 N109SGreenair Corp · Memphis, TNBuilt 1958 · S/N TD-140 N109SWChugiak Aviation Leasing LLC · Chugiak, AKBuilt 1977 · S/N U20603799 N109TYFly Wide LLC · Lewes, DES/N E-2235 N109VKeeling Rodney E · Pearce, AZBuilt 1960 · S/N CD-160 N109WESpace Coast Aircraft Co · Merritt Island, FLBuilt 1978 · S/N 347870405 N109WYPerala Daniel R · Cheyenne, WYBuilt 1969 · S/N 18260131 N109YBraun Joshua S · Port Hope, MIBuilt 1962 · S/N 18253513 N10AAPeterson Andrew · Louisville, KYBuilt 1966 · S/N 320E0046 N10ADTeerlink Randall S · Hanover, VABuilt 1976 · S/N 20-1221 N10AKCygnus Holdings LLC · Ballwin, MOBuilt 1969 · S/N TE-765 N10ARK Airmotive LLC · St Helens, ORBuilt 1966 · S/N U206-0738

Back to AD 98-21-21 R1