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.

N241AJAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1958 · S/N 35789 N241AREllison Aviation LLC · Conroe, TXBuilt 1967 · S/N 320F-0012 N241ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496039 N241CFPalermo Michael S · Carter Lake, IABuilt 1957 · S/N 23-1160 N241DAMonard Larry R · Anadarko, OKBuilt 1960 · S/N 57563 N241EPiedmont Aviation Leasing LLC · Monticello, GABuilt 1971 · S/N 17259889 N241GAAdvanced Air Leasing LLC · Kissimmee, FLS/N CE-1447 N241HAMcfarland Mark C · Cottage Grove, ORBuilt 1960 · S/N CD-84 N241HHOddson Terrance J · Windom, MNBuilt 2001 · S/N E-3427 N241HPWest Palm Breathe Free And Wellness LLC · West Palm Beach, FLBuilt 1984 · S/N 25-0804 N241JAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 28020011 N241JPNate Nelsen LLC · Enterprise, ALBuilt 1963 · S/N 30-241 N241KSCrane Kermit J · Topeka, KSBuilt 1973 · S/N 17262602 N241LWDrouin William · Brookline, NHBuilt 1970 · S/N 700088 N241NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 1999 · S/N 2842051 N241NPNauti Plane LLC · Wilton Manors, FLBuilt 1968 · S/N TE-648 N241NYColonial Aviation LLC · N Prince George, VAS/N 17256479 N241PBTranstek International Inc · Deerfield, ILBuilt 1964 · S/N 27-2589 N241RSalamon Uri · Boerne, TXBuilt 1980 · S/N CE-925 N241RCReynolds Thomas H · Toms River, NJBuilt 1981 · S/N 24-1121 N241RDRegistration Pending · Missoula, MTRegistration pendingBuilt 1975 · S/N 18502934 N241RGAmerican Patrols Inc · Midland, TXBuilt 1973 · S/N 17261916 N241SECarrie Chad Michael · Fort Worth, TXBuilt 2006 · S/N 3246241 N241SRLeman Joseph A · Anchorage, AKBuilt 1965 · S/N 18256316 N241TFAir Fleet Holdings LLC · Missoula, MTBuilt 2023 · S/N 4496559 N241TNWilmoth Matthew L · Traverse City, MIBuilt 1979 · S/N 27-7954110 N241VUDynamic Aircraft Services LLC · Hurst, TXS/N 28-7515409 N241WFInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 31-7852073 N241WMWildman Air LLC · Mckinney, TXBuilt 1973 · S/N 18502253 N241WSSun Moon Star LLC · Springfield, MOBuilt 1999 · S/N TH-1922 N241ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881610 N2420DThomas Ryan J · Anchorage, AKBuilt 1952 · S/N 20572 N2420SNighthawk Inc · Dallas, TXBuilt 1962 · S/N 18051139 N2420UAylmer Debra L · Black Creek, GABuilt 1963 · S/N 17250020 N2421CGeisler Mark · Dallas, TXBuilt 1954 · S/N 30721 N2421FDeckload Aviation LLC · Kodiak, AKBuilt 1965 · S/N 18051621 N2421LPerdue Dustin W · Mooresville, INBuilt 1966 · S/N 17255621 N2421QAristigue Brothers LLC · Sierra Vista, AZBuilt 1966 · S/N 18257621 N2421RMerryman Todd K · Shickley, NEBuilt 1969 · S/N 28-5618 N2421UWiney Jonathan · Michigan City, INS/N 17250021 N2421WJohnston John · Sheboygan, WIBuilt 2023 · S/N 2881631 N2421XMills Michael N Jr · Granbury, TXBuilt 1965 · S/N 18256321 N2421YAzflygal LLC · Phoenix, AZS/N 17249721 N24227Styer Michael J · Amarillo, TXBuilt 1955 · S/N 31504 N2422LTravis Equipment LLC · Bee Cave, TXBuilt 1966 · S/N 17255622 N2422RAbecca Corp · Jackson, MIBuilt 1964 · S/N 18255522 N2422UDennissan LLC · Noble, OKBuilt 1979 · S/N 32R-8029002 N2422YMarker Aviation LLC · Keller, TXBuilt 1966 · S/N 28-3171 N2423ACcf Ventures Inc · Bangor, MES/N 18504225 N2423DWatkins Veronica J Trustee · Sparks, NVBuilt 1952 · S/N 20575

Back to AD 98-21-21 R1