Registered aircraft · 85,616

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.

N122CERay Kevin T · Columbus, TXBuilt 1979 · S/N E-1475 N122CTTurner Eye Clinic Inc · Cabot, ARBuilt 1976 · S/N TE-1070 N122DDBeacon Hill Leasing LLC · Plymouth, MIBuilt 1977 · S/N 27-7754120 N122EOne Two Two Echo Aviation LLC · Cincinnati, OHBuilt 1973 · S/N 310Q0984 N122FSiver Creek Capital LLC · Emery, SDS/N 21058967 N122GTSperr Adam C · Donnelly, MNBuilt 1980 · S/N E-1673 N122HSMarbury Sherri E · Jackson, TNBuilt 1965 · S/N 28-2377 N122JSGraham Design Services Inc · Dawsonville, GABuilt 1979 · S/N 18266866 N122KSPt Arts LLC · Grand Rapids, MIBuilt 1966 · S/N 17255255 N122KTRustair Inc · Anchorage, AKS/N 32-7940190 N122LDennis Harley E Sr · Cole Camp, MOBuilt 1956 · S/N D-4579 N122LGStewart John H · Burlington, COBuilt 1988 · S/N E-2413 N122MCShouk Aviation LLC · Waverly, OHBuilt 2007 · S/N 2844133 N122MJHyper Flight Inc · Seattle, WABuilt 1977 · S/N 17270043 N122MWWalker Kyle E · Lawrence, KSBuilt 1979 · S/N R18201276 N122NAGilded Gull Aviation LLC · Middletown, RIBuilt 1981 · S/N 28-8216068 N122PGMcgaw Thomas D · Petaluma, CABuilt 1961 · S/N TC-149 N122PWKal Aero Flight Instruction LLC · Mattawan, MIBuilt 1966 · S/N 17255433 N122RCCurtis Alvis Jr · Bakersfield, CAS/N 21059298 N122RHPadussis Gary Theodore · Cape May, NJBuilt 1993 · S/N 93-301017 N122RLJenaero LLC · Cincinnati, OHBuilt 1978 · S/N TC-2177 N122RMHolland Mark Drew · San Antonio, TXBuilt 1984 · S/N TH-1416 N122RPWerner Bryce R · Blue Earth, MNBuilt 1966 · S/N 17254543 N122RRDebold David A · Spring, TXBuilt 1961 · S/N D-6706 N122SBCessna Twin Flyers LLC · Calhoun, TNS/N 310R0873 N122SJDeloof Dion S · Austin, TXBuilt 1963 · S/N D-7118 N122SNKinsey Timothy James · La Grange, TXBuilt 1979 · S/N D-10283 N122SSGrain Belt Aviation LLC · Malcolm, NEBuilt 1975 · S/N 17264842 N122TEBouchillon James R · Hanahan, SCBuilt 1972 · S/N 32-7340044 N122TGAnzalone Donald Michael · Durango, COBuilt 1980 · S/N 18267533 N122TTEveraert Filip L · Midland, MIBuilt 1974 · S/N 18262858 N122TWJmi Associates LLC · Wilmington, DEBuilt 1975 · S/N D-9794 N122VCTurner Terrance A · Anchorage, AKBuilt 1973 · S/N 18502203 N122VWJk Aviation LLC · Fresno, CAS/N D-6435 N122WTStoimenov Kirill H · San Andreas, CABuilt 1977 · S/N 18266094 N1230TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250268 N1230UPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020277 N1230XMarquez Christopher · Gaithersburg, MDBuilt 1963 · S/N 104 N1230ZC & J Air Inc · Middleton, DEBuilt 1994 · S/N E-2875 N1231DNeel Aviation LLC · Lakeland, FLBuilt 1950 · S/N 19785 N1231FRegistration Pending · Wasilla, AKRegistration pendingBuilt 1975 · S/N 18502793 N1231PTwin Oaks Airpark Inc · Hillsboro, ORBuilt 1955 · S/N 23-251 N1231WMusa Adam · Princeton, NJBuilt 1967 · S/N 670099 N1231ZD&J Vtail LLC · Punta Gorda, FLBuilt 1961 · S/N D-6693 N1232FLloyd Land Plane I LLC · Brighton, COBuilt 1975 · S/N 18502794 N1232TAlexander Charles W · Slidell, LABuilt 1972 · S/N 28-7225430 N1232UOrganization Of Black Aerospace Professionals Inc · Westchester, ILS/N 17266928 N1232WMilam David N · Hannibal, MOBuilt 1967 · S/N 670088 N12330Liller Kenneth F · New Port Richey, FLBuilt 1973 · S/N 17261932 N12331N Conti Inc · Boyertown, PABuilt 1973 · S/N 17261933

Back to AD 98-21-21 R1