OpenAirDocs.org
AD 98-21-21 R1

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
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.

N23PCHenderson Aviation Inc · Abingdon, VAS/N TH-2071N23PFBagge Tom · Monticello, IABuilt 1968 · S/N 310P0044N23PGPettis Dale R · Farmington, MNBuilt 1986 · S/N E-2324N23PVLake Dana · Boxford, MAFirst renewal noticeBuilt 1987 · S/N TH-1513N23RDRegistered aircraftS/N 30-469N23RGRogers Ralph R · Winifred, MTBuilt 1964 · S/N 185-0693N23RMMurray Michael G · Olathe, KSBuilt 1964 · S/N D-7311N23RWTirpak Garrett J · Daphne, ALBuilt 1977 · S/N 32R-7780535N23SFTarhanick Timothy P · Livonia, MIBuilt 1971 · S/N 21059547N23SJRatnikov Dmitry · Jay, NYBuilt 1981 · S/N EA-222N23TACor Yan · San Juan, PRBuilt 1978 · S/N 27-7854114N23THLudlow Christopher C · Redding, CABuilt 1966 · S/N CD-1019N23TPKarel Benjamin · Stillwater, MNS/N CE-870N23VVRoberts Daniel L · Westerville, OHBuilt 1990 · S/N CE1490N23WBQualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 27-7405281N23WGSamson Ryan · Escondido, CABuilt 1963 · S/N 27-565N23WRCraft Enterprises IV LLC · Beavercreek, OHBuilt 1981 · S/N E-1827N2400Ticknor Rodney J · Bridgewater, IABuilt 1967 · S/N 28-4586N2400CFloyd William W · Anchorage, AKBuilt 1954 · S/N 30700N2400DCrummett James F · Redding, CABuilt 1952 · S/N 20552N2400QGc10 Aero LLC · Birmingham, ALBuilt 1966 · S/N 18257600N2400RJenkins Clayton S · Brock, TXBuilt 1964 · S/N 18255500N2400YClark Nikita C · Ontario, ORFirst renewal noticeBuilt 1962 · S/N 17249700N2400ZDerr Douglas N · Woodlands, TXBuilt 1957 · S/N DH-137N24012Grubba Gregory T · Anchorage, AKBuilt 1974 · S/N U206-02237N2401GKidd Alexander P · Nashville, TNBuilt 1958 · S/N 51701N2401LDelta Ridge Farms LLC · Oak Grove, LAS/N 17255601N2401RSky182 LLC · Eugene, ORS/N 18255501N2401YBeauchamp William J · Rigby, IDBuilt 1962 · S/N 17249701N2402ALaurelton Village Inc · Alamance, NCS/N TC-1931N2402LLehman Michael N · Lansing, KSBuilt 1966 · S/N 17255602N2402RSmith Porter Allen · Aztec, NMBuilt 1964 · S/N 18255502N2402XTeeter Ralph R · Caldwell, IDS/N 18256302N2403GZeus Air Inc · Wilmington, DEBuilt 1958 · S/N 51703N2403LSeibert Richard L · Gibsonia, PABuilt 1966 · S/N 17255603N2403QSkydive Harbor Springs Inc · Charlevoix, MIBuilt 1966 · S/N 18257603N2403RDuck Dennis H · Jefferson City, TNBuilt 1964 · S/N 18255503N2403UFloyd Carson K · Elberton, GABuilt 1962 · S/N 17250003N2403YLarkin Timothy J · Pearland, TXBuilt 1962 · S/N 17249703N24041Texas Flight Training Aircraft 8 LLC · Wilmington, DEBuilt 2010 · S/N 4496290N2404CWatts Noah D · San Antonio, TXS/N 30704N2404FDe Vries James S · Pacific, MOS/N 18051604N2404LStalder David L · Amanda, OHBuilt 1966 · S/N 17255604N2404QHoch Lance M · New Plymouth, IDFirst renewal noticeBuilt 1966 · S/N 18257604N2404YRegistration Pending · Rexburg, IDRegistration pending, pending cancellationBuilt 1962 · S/N 17249704N2404ZSutherland Kurt Aron · Valley View, TXBuilt 1981 · S/N 18267897N2405GWarren Sam A Jr · Stanwood, WABuilt 1959 · S/N 51705N2405MFree Flyers Avionics Inc · Kerkhoven, MNBuilt 1979 · S/N 27-7954049N2406CRopps Spraying Service Inc · Pasco, WABuilt 1954 · S/N 30706N2406QSteely John R · Anderson, SCBuilt 1966 · S/N 18257606
Back to AD 98-21-21 R1