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.

N1841WN1841w LLC · Plant City, FLBuilt 1973 · S/N CE-437N1841XBoland Thomas · Pewaukee, WIBuilt 1964 · S/N 18255941N1841YSegroves Chris · Clarkston, WAS/N 17249441N18429Withers John Justin · Paris, TXS/N CE-937N1842CSmith Ronald Raymond · Willows, CABuilt 1953 · S/N 25986N1842DCoughlin Patrick J · Nashua, NHBuilt 1952 · S/N D-3098N1842JAgthe Thilo Claus · Highlands, NJBuilt 1968 · S/N 28-24277N1842TPowell Gary · South Jordan, UTBuilt 1971 · S/N 28-7125273N1842WNorthwoods Aviation · Marion, IAS/N CE-438N1842XRichey Perry A · Willow, AKBuilt 1964 · S/N 18255942N1842ZVermont Skydiving Adventures Inc · Bristol, VTBuilt 1962 · S/N 205-0042N18431Stall Benjamin A · Piedmont, OKBuilt 1977 · S/N E-1129N18433J4 Aviation LLC · Lexington Park, MDBuilt 1977 · S/N TK23N1843DSales Joe H · Seminole, TXBuilt 1952 · S/N D-3111N1843FJordan Jay · Centre, ALBuilt 1966 · S/N 21058743N1843JMerlina Michael · North Reading, MABuilt 1968 · S/N 28-24278N1843LRegistered aircraftS/N TJ-65N1843TWalko Timothy A · Florence, MAS/N 28-7105117N1843ZVacek George T Jr · Anchorage, AKBuilt 1962 · S/N 205-0043N18446Descro Air LLC · Henderson, KYBuilt 1977 · S/N TC-2086N18448Redd Horse LLC · Wilmington, DEBuilt 1977 · S/N TC-2087N1844DSalimi Patrick · Shingle Springs, CABuilt 1952 · S/N D-3141N1844JSwanberg Brian M · Federal Way, WABuilt 1968 · S/N 28-24279N1844LRao Enterprises LLC · Brighton, MIBuilt 1976 · S/N D-9880N1844XSmith James E · Cuba, MOBuilt 1964 · S/N 18255944N1844ZN1844z LLC · Hillsboro, ORBuilt 1962 · S/N 205-0044N18456Hewson Robert A · Santa Barbara, CABuilt 1977 · S/N E-1131N18457Colwell Arthur R · Magnolia, TXBuilt 1977 · S/N E-1133N18459Iglesia De Cristo · Porter Ranch, CABuilt 1977 · S/N E-1134N1845FJones Sandy Ray · Williamsburg, NMS/N 21058745N1845VSkypark Inc · Wadsworth, OHBuilt 1974 · S/N 17263769N1845XFry Richard R · Marana, AZBuilt 1965 · S/N 18255945N1845YAlpha Aviation Holdings Group LLC · Raleigh, NCBuilt 1962 · S/N 17249445N1845ZQuale Scott M · New Town, NDBuilt 1978 · S/N 180-52973N18462Sayers James B · Edison, OHBuilt 1977 · S/N E-1140N18463Bickett James C · Central City, KYS/N E-1137N18469Bonanza 469 LLC · Visalia, CABuilt 1977 · S/N E-1141N1846CNorthwest Intl Aviation · Seattle, WABuilt 1953 · S/N 25990N1846TSatern Tate P · Dakota City, IABuilt 1971 · S/N 28-7105119N1846WChristenson R Darren DBA · Vernal, UTBuilt 1977 · S/N E-1138N1846YMuldoon Anthony P · Howell, MIS/N 17249446N1846ZFullerton Thomas M · Centennial, COBuilt 1978 · S/N 180-52968N18470Entwistle Charles W · Leicester, MABuilt 1977 · S/N D-10065N18472Cherry Michael · Corolla, NCBuilt 1978 · S/N TC-2155N18474Sacandaga Air Inc · Fort Plain, NYS/N E-1309N18475Gerlach And Associates LLC · Valparaiso, INBuilt 1977 · S/N TH-879N1847HQuantum Fly Corp · Boca Raton, FLS/N TK-145N1847JMehrle Properties LLC · Mcclure, ILBuilt 1968 · S/N 28-24283N1847RNugent Properties LLC · Wasilla, AKFirst renewal noticeBuilt 1974 · S/N 18502562N1847TMayer Joseph J · Rolling Meadows, ILBuilt 1971 · S/N 28-7105120
Back to AD 98-21-21 R1