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.

N18DLBelov Mikhail · Greenwood Village, COBuilt 1977 · S/N 310R1251 N18DMRachal Randolph B · Taft, TXBuilt 1969 · S/N 18259374 N18DRBurns Donald N DBA · Watkinsville, GABuilt 1978 · S/N E1228 N18EBAll American Aviation LLC · East Helena, MTBuilt 1974 · S/N 17264188 N18EWCahill Thomas · Queensbury, NYBuilt 1966 · S/N CE-22 N18FGShapiro David Ely · Brookhaven, GABuilt 1974 · S/N 17264233 N18FTSk Ventures LLC · Hamilton, MTBuilt 1976 · S/N 32-R-7780126 N18HBBuermann Henry · Brookfield, VTS/N 30912 N18HLBusinessliner Inc · Ft Lauderdale, FLBuilt 1980 · S/N 31-8052055 N18HMYoung Craig · Ada, MIBuilt 1975 · S/N TH-651 N18HRJ & R Aviation LLC · Hamilton, OHBuilt 1967 · S/N 17256269 N18JHGarnet Aerospace LLC · Windsor, COBuilt 1963 · S/N TC-495 N18JKTalley Warbirds Inc · Longview, TXBuilt 1969 · S/N 690020 N18KFNelco Inc · Blanchard, OKBuilt 1978 · S/N E-1251 N18KNAeroventures Flying Club Inc · Lilburn, GABuilt 1979 · S/N 28-7911297 N18LHKrystal Sky Aviation LLC · Melbourne, FLBuilt 1998 · S/N 32-57058 N18LLPiping Technology Consultants Inc · Monee, ILBuilt 1978 · S/N E-1332 N18MDN18md Aviation LLC · Salem, ORBuilt 1967 · S/N TE-455 N18MJFleeman Julie · Laguna Niguel, CABuilt 1978 · S/N E-1250 N18MUHobgood Mitchell D · Tylertown, MSS/N 28-3561 N18MWRed State LLC · Daytona Beach, FLBuilt 1967 · S/N 27-3691 N18NFR D Aviation LLC · Phoenixville, PABuilt 1967 · S/N 21058903 N18NJTennessee Dept Of Saftey & Homeland Security · Nashville, TNBuilt 1978 · S/N R18200178 N18PBStogner Terry W · Lamesa, TXBuilt 1967 · S/N 18258216 N18PWPhenix LLC · Dayton, WABuilt 1963 · S/N 21058192 N18RBDuval Kenneth M · Richardson, TXBuilt 1973 · S/N CE-461 N18RJDocs Air LLC · Diamondville, WYS/N 27-4382 N18RKJacksonville Twin Comanche LLC · Kalispell, MTFirst renewal noticeBuilt 1979 · S/N 34-7970151 N18RLAlpha Whiskey 3 LLC · Brandon, MSBuilt 1979 · S/N 31-7952090 N18SBTroy Motz Construction Inc · Lincolnton, NCBuilt 1978 · S/N 18266338 N18SCSpencer Clyde V · Queen Creek, AZBuilt 1977 · S/N TJ-111 N18SGBennett Jeannette DBA · Joiner, ARFirst renewal noticeBuilt 1975 · S/N 310R0560 N18STYoung Shawna Hodges · Turlock, CABuilt 1973 · S/N 17261795 N18SWShannon Kenneth J · Cleveland, TXBuilt 1973 · S/N 28-7425049 N18TKMcpherson Kathrynne Alexine Trustee · Twin Falls, IDBuilt 1961 · S/N 18253360 N18TLCarey Nicolas J · Rosamond, CAS/N 18259225 N18TPPotter Todd J · Warrens, WIBuilt 1979 · S/N 34-7970431 N18TUCheck Seven LLC · Champaign, ILBuilt 1967 · S/N D-8450 N18VGBullet Aviation LLC · Missoula, MTBuilt 1999 · S/N E-3255 N18VJAssurance Data Inc · Indiana, PABuilt 1984 · S/N TJ-445 N18VRVentura Air LLC · Wilmington, DEBuilt 1996 · S/N TH-1771 N18VUVincennes University · Vincennes, INBuilt 1977 · S/N 310R0928 N18WLMiller Christopher M · Centreville, VABuilt 1981 · S/N 18053178 N18WMIsland Cay Express Inc · Wilmington, DEBuilt 1980 · S/N 32-8006047 N18WPPacker William M · Orchard Lake, MIBuilt 1966 · S/N D-8125 N18WRN18wr LLC · Mesa, AZS/N 28-8190185 N18WWFourth Sister LLC · Wilmington, DEBuilt 1994 · S/N E-2860 N18XBecker James · Crystal Lake, ILBuilt 1978 · S/N E-1353 N18ZPPierce Lestley R · Henderson, NVS/N 18263562 N1900UBismarck Aero Center · Bismarck, NDBuilt 1979 · S/N 17273162

Back to AD 98-21-21 R1