Registered aircraft · 85,612

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.

N310ZFlyin' Dog Air LLC · Niceville, FLBuilt 1979 · S/N 310R1573 N3110ATalon Group LLC · Marietta, GABuilt 1979 · S/N TC-2207 N3110FVillalobos Isaac M · Lake Havasu City, AZBuilt 1966 · S/N 18257214 N3110LYellowfin Aero LLC · Seminole, TXS/N 310J0110 N31110Anica Properties LLC · Chandler, AZBuilt 2005 · S/N 3449319 N3111DMonarch Air Services LLC · Ballwin, MOBuilt 1994 · S/N E-2874 N3111FShaw Construction Inc · Hillsboro, OHBuilt 1966 · S/N 18257211 N3111HMcniel George A · Portland, ORBuilt 1987 · S/N CE-1168 N3111JAir Arkansas Inc · Wilmington, DEBuilt 1987 · S/N CE-1192 N3111KChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 4496240 N3111RFetterman Robert J · Newport, MIBuilt 1967 · S/N 18258511 N3111SMiller Bruce E · Lake Oswego, ORBuilt 1964 · S/N 18255611 N3111USmith Skipper R · Gulfport, MSBuilt 1963 · S/N 18254511 N3111VStewart Ladd E · Augusta, KSBuilt 1947 · S/N D-533 N3111WChubb Oil & Gas LLC · Missoula, MTBuilt 1967 · S/N D-8573 N31121Full Flaps 2 LLC · Peachtree City, GABuilt 1988 · S/N E-2428 N31122Ross Jeremy · Lufkin, TXBuilt 2005 · S/N 3257394 N3112BParslow Wayne · Puyallup, WABuilt 1952 · S/N 25354 N3112CBagley Benjamin H · Rome, GAS/N 30911 N3112DGrossman Steve B · Chouteau, OKBuilt 1977 · S/N 18052885 N3112QWelch Phillip A · Abilene, TXBuilt 1977 · S/N 28-7710023 N3112SKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1964 · S/N 18255612 N3112UDavis James M · Tuscaloosa, ALBuilt 1963 · S/N 18254512 N3112XRichards Timothy T · Sherborn, MABuilt 1988 · S/N CE-1220 N3112YWykoff Donald W · West Chester, OHBuilt 1988 · S/N E-2410 N3113DWooliver Steve P · Wasilla, AKBuilt 1955 · S/N 31911 N3113GChristiansen Thad Charles · Spring Grove, ILBuilt 1988 · S/N CE-1252 N3113NTorgerson Glenn Allen · Snohomish, WABuilt 1988 · S/N CE-1250 N3113QTj Enterprises LLC · Stayton, ORS/N 18258113 N3113RMyers Richard · Sugar Land, TXBuilt 1967 · S/N 18258513 N3113UBravo Lima LLC · Tampa, FLBuilt 1962 · S/N 18254513 N3113VMurrell Louis B · Wichita, KSS/N D-535R6 N3113YYorkwind LLC · Gilford, NHBuilt 1962 · S/N 18254113 N31143Mjj Aircraft Inc · Wilmington, DEBuilt 1988 · S/N E-2443 N3114ATavallaee Mehran Monazam · Crossville, TNBuilt 2008 · S/N 3257490 N3114LResendiz Marcelino · Alamo, TXBuilt 1965 · S/N 310J0114 N3114QBaird Steven L · Chapel Hill, TNBuilt 1967 · S/N 18258114 N3114RCrews David Mason · Manteo, NCBuilt 1967 · S/N 18258514 N3114VWheeler Jack W · Greensboro, NCBuilt 1947 · S/N D-536 N3114YN635v LLC · Nacogdoches, TXBuilt 1988 · S/N E-2441 N3115BKegley Gary L · Perrin, TXBuilt 1952 · S/N 25357 N3115DSmith Gregory · Lewistown, MTBuilt 1955 · S/N 31913 N3115FTritec Air LLC · Tower, MNS/N 18257215 N3115QThomas Charles S · Barstow, CAFirst renewal noticeBuilt 1967 · S/N 18258115 N3115SHamric James H · Ward, ARBuilt 1964 · S/N 18255615 N3115WBenson James M · Cleveland, TNBuilt 1973 · S/N E-497 N3116ASchanche Carsten H · Marstons Mills, MABuilt 1953 · S/N 25760 N3116CNorthfork Aviation LLC · Columbia, MOS/N 3246233 N3116RWoodruff James Michael Richard · Wasilla, AKBuilt 1967 · S/N 18258516 N3116SRose David J · West Mansfield, OHBuilt 1964 · S/N 18255616

Back to AD 98-21-21 R1