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.

N23AFGuilded Gull Aviation LLC · Middletown, RIBuilt 1974 · S/N 28-7415702 N23AGParker Robert B · Trussville, ALBuilt 1975 · S/N D-9834 N23ALPv Aviation LLC · Poland, OHBuilt 1981 · S/N 32R-8213008 N23ASRusso James F · Liberty, SCS/N 27-3094 N23ATCalifornia In Nice Inc · San Jose, CABuilt 1978 · S/N 17270997 N23AUAverett University · Danville, VABuilt 2024 · S/N 4496570 N23AVJtz Aviation LLC · Wilmington, DEBuilt 1981 · S/N 27-8154003 N23AZNix Jacob DBA · Johnson, KSBuilt 1974 · S/N 18502499 N23BMAxiom Development And Consulting LLC · Atlanta, GABuilt 1959 · S/N 24-1118 N23CCulver Marc D · Anchorage, AKS/N 18256046 N23CBNb Tweet And Sons · Nome, AKS/N 18503331 N23CCMadrid Jorge M · Tucson, AZBuilt 1967 · S/N 185-1236 N23CLRsr Medical Inc · Wilmington, DEBuilt 1995 · S/N E-2969 N23DBSky High Farmers LLC · Lakeville, MNBuilt 1975 · S/N 17264474 N23DDK Tahoe Air LLC · Glendale, CABuilt 2023 · S/N 2881676 N23DHOrtiz Guillermo · Puyallup, WABuilt 1975 · S/N 18264053 N23DLKnight Robert T · Baton Rouge, LAS/N D-7363 N23ECDenver Aero Service Marine Inc · Wilmington, DEBuilt 1975 · S/N TC-1894 N23EPErid Air LLC · Blackfoot, IDBuilt 1954 · S/N D-3858 N23FOurada Mary E Trustee · Tulsa, OKBuilt 1962 · S/N 205-0073 N23FAHayes David B · Betsy Layne, KYBuilt 1960 · S/N 27-52 N23FBHektner Douglas M · Girdwood, AKBuilt 1966 · S/N 185-1186 N23FGState Of California Dept Of Fish & Game · Sacramento, CABuilt 1980 · S/N 18504035 N23FLQualitair LLC Trustee · MichelstadtS/N 250295 N23GDPhoenix Composite Solutions LLC · Oscoda, MIBuilt 1978 · S/N 17270903 N23GHKnuth Dean · Lincoln, NEBuilt 1950 · S/N D-2435 N23GNMidwest General And Mechanical Contractors Inc · Highland, WIS/N 23-1415 N23GVCongressional Flying Club · Gaithersburg, MDBuilt 1974 · S/N 17264594 N23HBHotel Bravo Aviation LLC · Houston, TXFirst renewal noticeBuilt 1977 · S/N 21062050 N23HLWood Douglas K · Martinez, CABuilt 1979 · S/N E-1509 N23JDraco Flight School Inc · Chino, CAS/N 310I0108 N23JCJet & Rotor Aviation LLC · Sacramento, CABuilt 1980 · S/N 348070121 N23JFSimba Air LLC · Mt Juliet, TNBuilt 1955 · S/N 26778 N23JTWhitman Michael V · Guys Mills, PABuilt 1972 · S/N 28-7325192 N23KBRegistered aircraftBuilt 1985 · S/N P21000845 N23KMR H Phillips Trucking Co Inc · Shelby, OHS/N TH-2116 N23LAWill Voyles Farms LLC · Wynne, ARS/N 32-7840045 N23LEMidstate Aviation 1 LLC · Owosso, MIBuilt 1981 · S/N 28R-8231021 N23LGGist Thomas Hottel III · Little Rock, ARBuilt 1959 · S/N 24-832 N23LHHill Lawrence E · Marion, MTBuilt 1974 · S/N 18502433 N23LKHernandez Byron Jr · Buffalo, NYBuilt 1976 · S/N 185-03085 N23MCFilm Fliers Inc · Orlando, FLBuilt 1976 · S/N 32R-7680190 N23MDBell William P · Gainesville, GABuilt 1981 · S/N 24-1247 N23MFTriay Services LLC · Metairie, LABuilt 1974 · S/N TC-1684 N23MGNewhall William G · Longmont, COBuilt 1971 · S/N 39-28 N23MMAmerica Atlantic Aviation Inc · Stuart, FLBuilt 1967 · S/N 32-40367 N23MZGulfstream Media LLC · Daytona Beach, FLBuilt 1972 · S/N 17260459 N23NANorthampton Aeronautics Inc · Northampton, MABuilt 1977 · S/N 28-7716036 N23NVAvk Air LLC · Harvest, ALBuilt 1977 · S/N 32R7780373 N23NYKahn Mitch · Scarsdale, NYBuilt 1987 · S/N E-2359

Back to AD 98-21-21 R1