Registered aircraft · 85,636

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.

N100TBAlexander Aviation LLC · Brighton, COBuilt 1963 · S/N CD-637 N100TCMckinney Richard P · Fayeteville, ARBuilt 1973 · S/N 28R-7335370 N100TEBlaney Robert L · Newark, OHBuilt 1975 · S/N 22-1255 N100TGBengtson Todd · Tyler, TXBuilt 1974 · S/N 310Q1150 N100TXJones Joseph Clayton · Bossier City, LABuilt 1976 · S/N D-9854 N100VFMeridian Aviation N100vf LLC · Mobile, ALBuilt 1977 · S/N 32R-7780539 N100WAAlcorn Stanley R · Sonora, CABuilt 1964 · S/N 17251499 N100WDEveryday Medicine LLC · Nicholasville, KYBuilt 1982 · S/N 32-8224008 N100WQCarolina Queen Inc · Oak Ridge, NCBuilt 1981 · S/N 28R-8131116 N100WSQualitair LLC Trustee · MichelstadtBuilt 1987 · S/N CE-1202 N100WWSwearengin David · Lula, GABuilt 1967 · S/N 28-23611 N100WYMcatee Mark D · Casper, WYBuilt 1959 · S/N 56439 N100XHBiggs Aircraft Inc · Wellston, OKBuilt 1999 · S/N E-3249 N100XPHeath Darrell L · Houston, TXBuilt 1991 · S/N CE-1564 N100XRTomsis Corp · Panama City, FLBuilt 1981 · S/N 31-8152169 N100YNEnrique Angulo · San Diego, CAS/N 21061236 N100YSLally Lawrence L · Mooresville, NCBuilt 1965 · S/N 17252400 N100YVPalmy LLC · Lander, WYBuilt 1991 · S/N 243194 N100ZZArbuckle George A · Poolville, TXBuilt 1975 · S/N TC-1922 N101Bene Mary D · Ketchum, OKBuilt 1964 · S/N 17252056 N1010ARussell Jerald Trustee · Pampa, TXBuilt 1988 · S/N 24-3079 N1010GHyde Kinder · Montgomery, ALBuilt 1989 · S/N 24-3098 N1010YGregory Kenneth · Crowley Lake, CABuilt 1970 · S/N 28R-35800 N1011Martin Rex L Trustee · Bakersfield, CABuilt 1980 · S/N 21064004 N1011NBlue Skies Aircraft LLC · Zephyrhills, FLBuilt 1970 · S/N 17259525 N1011SAfrican American Airlines Inc · Brandon, FLBuilt 1964 · S/N 310I0092 N1012XSunbeam Air Operations LLC · Wilmington, DEBuilt 1975 · S/N 28R-7535215 N1013USiry Stanley A · Burke, VAS/N 24-3101 N1013XBtm Aero LLC · Mansfield, TXS/N 28R-7535216 N10143Fatdog LLC · Voorhees, NJBuilt 1981 · S/N 24-1107 N1014FPeppard Kenneth W · Dumfries, VABuilt 1979 · S/N 17272931 N1014TInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N R18201650 N1014UStubblefield Daniel R · Lake Havasu City, AZS/N 24-3106 N1014WAnderson Timothy R · Wilmette, ILBuilt 1973 · S/N TE-906 N1015EBrown Richard T · Anaheim, CABuilt 1965 · S/N 255 N1015FInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 18502684 N1015QMayo William J Jr · Reed Point, MTBuilt 1962 · S/N 310H0015 N1015SJacobs Forest R · Vero Beach, FLS/N 24-3107 N1015WStanton Thomas Michael · Mcallen, TXBuilt 1973 · S/N TE-907 N10162Crespi Tony D · Meriden, CTBuilt 1981 · S/N 25-0561 N10165N10165 Corp Trustee · Wilmington, DEBuilt 1981 · S/N 25-0562 N10167Sterling Air LLC · La Quinta, CABuilt 1981 · S/N 25-0563 N1016FFly Cadillac LLC · Tustin, MIS/N 17272932 N1016UBlueskys Inc · Wilmington, DEBuilt 1982 · S/N 25-0727 N1016WMichael Deem Crow · Pilot Point, TXBuilt 1973 · S/N D-9478 N10176Abm Flights LLC · Pawleys Island, SCBuilt 1969 · S/N 18260141 N1017FImwalle John N · Batavia, OHS/N 24-3108 N1017GAustin Byrum Andrew C · Rogers, ARBuilt 1981 · S/N 25-0547 N1017LTop Gun Aviation Inc · Quinnesec, MIBuilt 1981 · S/N 25-0615 N1017MOstroff Nathaniel S · Summerland Key, FLBuilt 1981 · S/N 25-0564

Back to AD 98-21-21 R1