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.

N1886HGoodwin Joseph N · Grass Valley, CABuilt 1959 · S/N 35986 N1886JJones Freddy D · Amsterdam, OHBuilt 1968 · S/N 28-24330 N1886TKoester Deborah J · Courtland, MNBuilt 1971 · S/N 28-7225020 N1886VAngelone Inc · Elkhart, INBuilt 1974 · S/N 17263782 N1886W86 Whiskey Corporation · Vineland, NJBuilt 1973 · S/N E-441 N1887CRiggs Eugene D · Shoreline, WAS/N 26031 N1887FHeadings Kevin · Echo, ORS/N 21058787 N1887TCulver Investments LLC · Gordon, TXBuilt 1971 · S/N 28-7225033 N1887ZDavidson David R · Sutton, AKS/N 205-0087 N1888CWayman Ian A · Peyton, COBuilt 1953 · S/N 26032 N1889CKlindworth Bo N · Beulah, NDBuilt 1953 · S/N 26033 N1889DKish James D · Centennial, COBuilt 1952 · S/N D-3161 N1889FPiper Henry Burton Jr · Kingston, TNBuilt 1966 · S/N 21058789 N1889HPlotnick Daniel G · Foxborough, MABuilt 1977 · S/N 28-7725166 N1889JBrain James E Jr · Rogers, ARBuilt 1968 · S/N 28-24334 N1889VCroome James Earl Jr · Sandersville, GABuilt 1974 · S/N 17263783 N1889WSabre 65 LLC · Helena, MTBuilt 1973 · S/N TH-341 N188ABSafford Aviation Service Inc · Coolidge, AZBuilt 1969 · S/N 32-40884 N188CRempfer David Dwayne · Chandler, AZS/N 27104 N188DHDunworth Jack R · Rutledge, GABuilt 1968 · S/N 680119 N188DXPiper Aircraft Inc · Vero Beach, FLS/N 28010104 N188GHAer Lightfoot LLC · Alpena, MIBuilt 1964 · S/N 525 N188HS&T Aviation LLC · Santa Teresa, NMS/N 50652 N188RCHodgskies Holdings LLC · Choteau, MTBuilt 1984 · S/N E-2189 N188RJWilliams Debbie C · Riverside, CABuilt 1963 · S/N D-7205 N188SEChernov Boris · Lima, OHBuilt 1978 · S/N 32R-7885255 N188SPThornado Aviation LLC · Indialantic, FLBuilt 1977 · S/N 32R-7780309 N188WW3l0 Air LLC · Chuluota, FLBuilt 1976 · S/N TJ-67 N188YMbaa Holding LLC · Myrtle Beach, SCBuilt 1964 · S/N TC-790 N1890DBrott Edwin T · Cincinnati, OHBuilt 1952 · S/N D-3173 N1890ZAlaniz Jose M · Yreka, CABuilt 1962 · S/N 205-0090 N1891CCoetzee Theo · San Luis Obispo, CABuilt 1953 · S/N 26035 N1891DDale Richard C · La Vernia, TXS/N D-3163 N1891MStarkman Timothy S · Monterey, CABuilt 1975 · S/N 18264470 N1891WSchwartz Eric · Timnath, COBuilt 1973 · S/N E-440 N1891YCarolina Sky LLC · Rock Hill, SCBuilt 1962 · S/N 17249491 N1892DLong Jory J · Lake Ozark, MOBuilt 1952 · S/N D-3164 N1892FPanagotacos George · Corona, CABuilt 1966 · S/N 21058792 N1892LMcnair Craig · Dayton, TXBuilt 1976 · S/N D-9897 N1892TB&R Aircraft LLC · Wadsworth, OHBuilt 1971 · S/N 28-7225042 N1892VSmith Air Inc · Ukiah, CABuilt 1974 · S/N 17263784 N1892XCuvar Philip M · Granite City, ILBuilt 1965 · S/N 18255992 N1892YBaker David Laurence · Nelson, WIS/N 17249492 N1893CFife Christopher R · Winslow, MEBuilt 1953 · S/N 26037 N1893FKleeman Mark · Kearney, MOFirst renewal noticeS/N 21058793 N1893LHarlan Blake · Trinity Center, CABuilt 1976 · S/N E-863 N1893YWhelan John J · Mount Vision, NYBuilt 1962 · S/N 17249493 N1894DAiken Wayne B Jr · Greenville, SCBuilt 1952 · S/N D-3166 N1894TIrish Dennis W · Erie, PABuilt 1971 · S/N 28-7225023 N1894XCorso Aviation LLC · Southlake, TXBuilt 1964 · S/N 18255994

Back to AD 98-21-21 R1