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.

N2382XRolleston Moreton M III · Canton, GABuilt 1965 · S/N 18256282 N2383AAero Traveler Ltd · Warminster, PABuilt 1969 · S/N D-9034 N2383XComo Aviation LLC · South Weymouth, MABuilt 1965 · S/N 18256283 N2383YAult Stanley K · Cinebar, WABuilt 1965 · S/N 21058583 N2384GAircraft Holdings LLC · Ellensburg, WABuilt 1958 · S/N 51684 N2384RMonroe Joel L · Alexandria, MNBuilt 1971 · S/N 28-7110003 N2384SChervenak A Douglas · Smyrna, DEBuilt 1976 · S/N 21061263 N2384XHill James P · Eagle Point, ORBuilt 1965 · S/N 18256284 N2385CSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1978 · S/N R18200172 N2385DHurst Gerald W · Bigfork, MTBuilt 1952 · S/N 20537 N2385TSquawk 1200 LLC · Springboro, OHBuilt 1971 · S/N 28-7225064 N2385UThomas Robert G · Eatonville, WABuilt 1962 · S/N 17249985 N2386CSuiter Thomas D · Earl Park, INBuilt 1978 · S/N R18200173 N2386DTitan Aero LLC · Wilmington, DEBuilt 1952 · S/N 20538 N2386ENiblack Ward Scott · Tecumseh, MIBuilt 1978 · S/N 17271261 N2386RLand Air & Sea LLC · Concord, NCBuilt 1970 · S/N 28-5602 N2386THub City Aviation Academy LLC · Lubbock, TXBuilt 1971 · S/N 28-7225065 N2386UBratton Beryl M · Yoncalla, ORS/N 17249986 N2387CEvans Randall B Trustee · Fallon, NVBuilt 1954 · S/N 30687 N2387FMitten Daniel L · Hatfield, PABuilt 1965 · S/N 21058587 N2387GPitsch Air Service · Grand Rapids, MIBuilt 1959 · S/N 51687 N2387RLeroux Fernand Dean · Lagrange, GABuilt 1964 · S/N 18255487 N2388CRicottilli Stanley L · Mill Creek, WVBuilt 1953 · S/N 30688 N2388GFlat Top Sheep Co · Carey, IDBuilt 1958 · S/N 51688 N2388URay Charlie B · Prosser, WABuilt 1963 · S/N 17249988 N2388XSeiler Richard · Bozeman, MTBuilt 1965 · S/N 18256288 N2389RB2fh Ltd · Allentown, NJBuilt 1964 · S/N 18255489 N2389SPhillips Aviation Enterprises Inc · Petoskey, MIBuilt 1979 · S/N R18201335 N2389UAllworth Ruger · Wapello, IABuilt 1962 · S/N 17249989 N238ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496037 N238DSRegistration Pending · Plainwell, MIRegistration pendingBuilt 1987 · S/N CE-1146 N238ESSutton Aircraft Salvage LLC · Palmer, AKBuilt 1960 · S/N 52854 N238FYSpace Coast Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841175 N238MCBrotherton Douglas E Trustee · Dubuque, IABuilt 1993 · S/N 3213047 N238MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881816 N238NDPlane Nonsense · Middletown, DEBuilt 2000 · S/N 2842101 N238SAzure II Flight Time LLC · Leesburg, FLBuilt 1965 · S/N CD-920 N238SAJmm Capital LLC · Fort Worth, TXBuilt 2000 · S/N E-3321 N238TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020238 N238WMMchatton Dret A · Redding, CABuilt 1967 · S/N 28-10924 N2390DNorman James C · Laguna Niguel, CABuilt 1952 · S/N 20542 N2390SPowerhawk Flyers LLC · Farmington Hills, MIBuilt 1976 · S/N 21061266 N2390TKessler Derek D · Lexington, OKS/N 28-7225068 N2390UKuhn Jacob H · Bloomer, WIBuilt 1962 · S/N 17249990 N2391FBlue Horizon Consulting LLC · Toccoa, GABuilt 1965 · S/N 21058591 N2391QNew Hamphire Flyers LLC · Lyme, NHBuilt 1977 · S/N 28-7790395 N2391TLotnicza LLC · Houston, TXBuilt 1971 · S/N 28-7225069 N2391UJeffway Robert W Jr · Leeds, MABuilt 1979 · S/N 32-7940253 N2392CRoot Eric J · Lakewood, COBuilt 1954 · S/N 30692 N2392FDingo Aviation LLC · Kalispell, MTBuilt 1965 · S/N 21058592

Back to AD 98-21-21 R1