Registered aircraft · 85,620

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.

N2326XFerris Elden L · Vancouver, WABuilt 1965 · S/N 18256226 N2327AN2327a LLC · Murrells Inlet, SCBuilt 1997 · S/N E-3127 N2327FWilliams Stephen Mark · Fort Walton Beach, FLBuilt 1964 · S/N 21058527 N2327TSale Reported · Hampton, GASale reportedBuilt 1971 · S/N 28R-7135216 N2327USprague Jeremiah A · Halfway, ORS/N 17249927 N23281Sosa Jonathan · Orlando, FLBuilt 1974 · S/N 17264082 N2328TElite Flight LLC · Lordstown, OHBuilt 1971 · S/N 28R-7135217 N23291Oracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 17264083 N2329DSwint David A · Henderson, NVBuilt 1952 · S/N 20481 N2329EMeshoppen Air LLC · Meshoppen, PABuilt 1978 · S/N 17271235 N2329GRegistration Pending · Eagle River, AKRegistration pendingBuilt 1959 · S/N 51629 N2329RRivers Andrew · Midland Park, NJS/N 18255429 N2329TColvin Timmy R · Valentine, NEBuilt 1971 · S/N 28-7110028 N232ASGuggenair LLC · Carbondale, COBuilt 1978 · S/N 310R1369 N232CASawdust Aviation Inc · Bellefonte, PABuilt 1976 · S/N 32-7740026 N232DXPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010032 N232FXAvp II LLC · Winnetka, ILBuilt 1993 · S/N E-2772 N232JBLundell Plastics Corp · Odebolt, IABuilt 1973 · S/N CE-448 N232JTBlezek Kent D · Tustin, CABuilt 1978 · S/N 24-0727 N232LSElliott Arthur M · Portland, TXBuilt 1971 · S/N 17260131 N232MGGeorgia Aviation Authority · Eastman, GABuilt 2025 · S/N 2881983 N232MTAir Force Life Cycle Management Center · Lexington, MABuilt 1981 · S/N U20606200 N232NTorbett Michael G · Lakeway, TXBuilt 1981 · S/N CE971 N232RSWright Aviation LLC · Lawton, OKBuilt 1974 · S/N 310Q1145 N232SPTucker Adam C · Clermont, FLBuilt 1978 · S/N 28-7990205 N232SUWard Simon James · Sylva, NCBuilt 1967 · S/N CE-172 N232TFAirmart Inc · Lexington, KYBuilt 2022 · S/N 2881550 N232TSTwo Tango Sierra LLC · Edmond, OKBuilt 1982 · S/N 32R-8229041 N232TTHinds Robert S Jr · Birmingham, ALBuilt 1981 · S/N 25-0448 N232WAFremont Motors Rocksprings Inc · Rawlins, WYBuilt 1981 · S/N 34-8233020 N232WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 28-21971 N232WVLewis And Clark Adventures LLC · Lewes, DEBuilt 1994 · S/N E-2906 N232YPGill Joshua Daniel · Tucson, AZS/N 24-3401 N2330EManhattan Flying Tigers Inc · Bozeman, MTBuilt 1978 · S/N 17271236 N2330GEmshwiller Mark E · Camp Verde, AZBuilt 1958 · S/N 51630 N2330TSteele Jackie L · London, KYS/N 28R-7130010 N2330XKeller Ronald B · Bosque Farms, NMBuilt 1965 · S/N 18256230 N2331DJensen William C · Brookshire, TXBuilt 1952 · S/N 20483 N2331FReeves Thomas W · Issaquah, WABuilt 1964 · S/N 21058531 N2331GSouth Bay Aviation Inc · Torrance, CAS/N 51631 N2331MSmith Ctr Kite Club Inc · Smith Center, KSBuilt 1977 · S/N 28-7890247 N2331RSawicki Michael T · Midland, MIBuilt 1964 · S/N 18255431 N2332CBalgoyen James T · Charlotte, MIBuilt 1954 · S/N 30632 N2332DSandstrom David · Anchorage, AKBuilt 1952 · S/N 20484 N2332EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271238 N2332JDon M Barron Contractor Inc · Farmerville, LABuilt 1999 · S/N E-3262 N2333BN2333b LLC · Oklahoma City, OKBuilt 1997 · S/N TH-1833 N2333CAfs Inc · Grants Pass, ORBuilt 1978 · S/N R18200152 N2333DTroutman Charles W · Prineville, ORBuilt 1952 · S/N 20485 N2333GRegistration Pending · Belen, NMRegistration pendingS/N 51633

Back to AD 98-21-21 R1