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.

N222DKVestal Randy L · Darien, GABuilt 1982 · S/N 25-0721 N222DLMattocks Mary E · East Amherst, NYBuilt 1971 · S/N 28-7125422 N222DRGoodknight Gregory W · Nevada City, CABuilt 1967 · S/N D-8604 N222DTClipper Sky LLC · Las Vegas, NVS/N D-10130 N222DUCg 340 LLC · Fountain Hills, AZBuilt 1973 · S/N 27-7305046 N222EFGillis Blake · Clinton, MOBuilt 1965 · S/N CD-928 N222ERGjg Air LLC · Amarillo, TXBuilt 1975 · S/N 18263978 N222ETValiair Lc Trustee · Casper, WYBuilt 1981 · S/N P21000626 N222EWGuzman Steven M · Port Saint Lucie, FLS/N 23-1539 N222FFReagan John · Knippa, TXS/N 18253725 N222FLPerkins Dwight L · Oklahoma City, OKBuilt 1970 · S/N 28-26582 N222FNRegistered aircraftBuilt 1985 · S/N CE-1075 N222FWLindsey Daniel Rey · Clovis, NMS/N 310I0002 N222GAYoung Robert A · Cass, WVS/N 28R-7931127 N222GDSolverson Aircraft Management LLC · Waunakee, WIS/N 2185 N222GESmith Daniel J · Mcmurray, PABuilt 1975 · S/N 32-7500020 N222GSLandau Management Services Inc · Topanga, CABuilt 1981 · S/N TJ384 N222HBUniversal Aviators Academy Inc · El Monte, CABuilt 1979 · S/N 28R-7918254 N222HCMuddflyers LLC · Woodbridge, VABuilt 1981 · S/N EA-259 N222HERound Engine Aero · Nashville, MIBuilt 1978 · S/N 17271191 N222HLDouble K Flying LLC · Scottsboro, ALBuilt 1961 · S/N 24-2670 N222HPHarrison Walter E · Taylor, TXBuilt 1982 · S/N R18201881 N222JBDelta U 84 LLC · Crown Point, INS/N E-1415 N222JGNoyes Jeffery A · Bridgeport, TXBuilt 1959 · S/N TD-215 N222JHRegistered aircraftBuilt 1974 · S/N 18263066 N222JLThomas Kent C · Muncie, INBuilt 1973 · S/N 32-7340135 N222JPI Am Aviation LLC · Pagosa Springs, COBuilt 1988 · S/N CE-1223 N222JWCarolina Aircraft Inc · Greensboro, NCBuilt 1989 · S/N CE-1401 N222KHPavco Inc · Gig Harbor, WABuilt 1973 · S/N 27-7305097 N222KRSharon Carl G · Brookshire, TXBuilt 1979 · S/N 24-0773 N222KSTriple Two Inc · Wilmington, DEBuilt 1976 · S/N 28-7790270 N222KTParker Che A · Franklin, INS/N 28-7415352 N222LTwo Motor Odor LLC · Paris, TXS/N 320E-0053 N222LSLj Bickford Companies LLC · Wasilla, AKBuilt 1972 · S/N U206-01751 N222LTRuskin Elizabeth M · Anchorage, AKBuilt 1998 · S/N 25-2029 N222MBCobb Joseph E · Cameron, TXBuilt 1964 · S/N TC-654 N222MDElx Aviation LLC · Hartford, MIBuilt 1974 · S/N 310Q1013 N222MHJones Jimmy N · Bremond, TXBuilt 1972 · S/N U20601931 N222MKOlson Kirk J · Dickinson, NDBuilt 1979 · S/N CE-881 N222MNMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881532 N222NARodriguez Lukas · River Oaks, TXBuilt 1974 · S/N 28-7415226 N222NDPlane Nonsense Inc · Middletown, DEBuilt 2001 · S/N 2842111 N222NWWilt Garry L · Pomona, CABuilt 1975 · S/N CE-573 N222PEPacific Air Charters Inc · Honolulu, HIBuilt 1976 · S/N 310R0632 N222PFStokes Brian L · Boulder City, NVBuilt 1979 · S/N R18201308 N222PGShokoohi Mehdi · Anaheim Hills, CABuilt 1973 · S/N TE-912 N222PJSchroeder James L · Rapid City, SDBuilt 1973 · S/N 28-7305259 N222PPPreferred Landing LLC · Tomball, TXBuilt 1978 · S/N 32R-7985013 N222PTFme Aviation LLC · Wheelersburg, OHBuilt 1978 · S/N 28R-7803342 N222PXRegistered aircraftBuilt 1976 · S/N 18265157

Back to AD 98-21-21 R1