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.

N3060QYarg Tap LLC · Midland, TXBuilt 1967 · S/N 18258060 N3060RArrow N3060r LLC · Sheridan, WYBuilt 1969 · S/N 28R-35621 N3060TPalumbo Henry R · Novato, CABuilt 1979 · S/N 28R-7931087 N3060UWhipple James M · Wadsworth, OHBuilt 1963 · S/N 17250660 N3060WRegistration Pending · Ojai, CARegistration pendingBuilt 1973 · S/N E-488 N3060YB&D Flight Club LLC · Portage, INBuilt 1979 · S/N 28-7916370 N30617Executive Flight Training & Services LLC · Sanford, NCBuilt 1974 · S/N 17264149 N30619Wrpl LLC · Mountain Brk, ALBuilt 1978 · S/N 34-7870467 N3061CTharp Aerospace LLC · Charleston, SCBuilt 1958 · S/N D-5757 N3061DJeppson Edward Mckay Trustee · South Jordan, UTBuilt 1956 · S/N 35261 N3061FTaber Deane W · Weirsdale, FLBuilt 1966 · S/N 18257161 N3061RCohns Willie · Elizabethtown, KYBuilt 1969 · S/N 28R-35622 N3061TAdventure Lab Aviation LLC · Saint George, UTBuilt 1979 · S/N 28R-7931088 N3061UWade William J · Waterman, ILS/N 17250661 N3061VRegistration Pending · Amboy, INRegistration pending, pending cancellationBuilt 1947 · S/N D-474 N3061WCcn Air LLC · Bloomington, INBuilt 1979 · S/N 32-7940079 N3061YHott Steven A · Kokomo, INBuilt 1979 · S/N 28-7990388 N3062FJohnson Sean D Trustee · Fresno, CABuilt 1966 · S/N 18257162 N3062LMerino Rodrigo R · Chilton, WIBuilt 1979 · S/N 28-7916252 N3062RBuddys Aviation LLC · East Bernstadt, KYBuilt 1979 · S/N 32R-7985084 N3062UMitchell Steven C · Knoxville, IABuilt 1963 · S/N 17250662 N3062WD M Aviation II Llp · Park River, NDBuilt 1979 · S/N 32-7940080 N3062YSwaringen Jeanne A · Lakeside, CABuilt 1979 · S/N 28-7990389 N3063AHartung Andrew K · Wasilla, AKBuilt 1953 · S/N 25707 N3063DCase William M · Klamath Falls, ORBuilt 1956 · S/N 35263 N3063FT J Croach Llp · Post Falls, IDS/N 18257163 N3063NConstantinides Chris · Chula Vista, CABuilt 1979 · S/N 28R-7931058 N3063PWillis William P Trustee · New Palestine, INS/N 23-981 N3063RGrant Scott A · Santa Barbara, CABuilt 1969 · S/N 28R-35624 N3063ULittle Bird Airways LLC · Hamburg, NYBuilt 1963 · S/N 17250663 N3063WReich Michael A · Woodside, CABuilt 1998 · S/N EA625 N30640Christianson Cleet M · Enumclaw, WABuilt 1978 · S/N 28R-7803369 N30643Hurst Gordon · Waterford, PABuilt 1974 · S/N 17264150 N30644Registered aircraftBuilt 1973 · S/N 21059949 N30647Registration Pending · Diamondhead, MSRegistration pendingBuilt 1978 · S/N 28-7816545 N3064AToribio LLC · San Antonio, TXBuilt 1953 · S/N 25708 N3064DLebron R Luke · Gulfport, MSS/N 35264 N3064UMcintosh Randall W · Rome City, INBuilt 1963 · S/N 17250664 N3064VLehmann Mark C · Trade, TNS/N D-478 N3064WDavid And Shirley Houchin LLC · Crescent City, FLBuilt 1973 · S/N D-9553 N3064YStemper Pete L · Madison, SDS/N 18254064 N30650Elite Flight Training And Aircraft Management LLC · Kankakee, ILBuilt 1978 · S/N 28-7916089 N3065ASouza Clifford A · Pattersonville, NYBuilt 1953 · S/N 25709 N3065BVanator John D · Eaton Rapids, MIBuilt 1978 · S/N 32R-7987043 N3065CVenture West LLC · Mesa, AZBuilt 1978 · S/N 28-7990152 N3065E3065e LLC · Westfield, PABuilt 1978 · S/N 17271425 N3065FHinds Frank E · San Angelo, TXBuilt 1966 · S/N 18257165 N3065KBowles William Jr · New Richmond, OHBuilt 1978 · S/N 28R-7918003 N3065QSuchy Michael R · Murrieta, CABuilt 1967 · S/N 18258065 N3065RFlavin Patrick J · Woodbridge, VABuilt 1969 · S/N 28R-35626

Back to AD 98-21-21 R1