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.

N140BKFrauenhoffer Kenneth E · Woodruff, WIBuilt 1975 · S/N 28-7525314 N140CKRegistered aircraftFirst renewal noticeBuilt 1969 · S/N 28-26210 N140DDBe Right Back Aviation LLC · Billings, MTBuilt 1971 · S/N 28-7125145 N140FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290175 N140FLYocum Stuart J · Kingman, AZBuilt 1971 · S/N 28-7125111 N140GBReel Christen · Leighton, ALBuilt 1967 · S/N 28 23806 N140HACarros Dale A · Cape Charles, VABuilt 1968 · S/N 28-25354 N140HCMurphy David B · Germantown, MDBuilt 1969 · S/N 28-25436 N140JFMeriden Aviation Center LLC · Meriden, CTBuilt 1973 · S/N 28-7325416 N140JGBarros Vincent · Kissimmee, FLBuilt 1974 · S/N 32-7400043 N140JNMfd Aviation Inc · Middletown, DEBuilt 1973 · S/N 28-7325244 N140KBMcclendon Dan · Burleson, TXBuilt 1979 · S/N EA 36 N140KW47 North Aviation LLC DBA · Wenatchee, WAS/N 28-7625121 N140LRutten Paul J · Pine Island, MNBuilt 1967 · S/N 28-23057 N140MDDesotel Mark · Fairfax, IABuilt 1973 · S/N 28-7425149 N140NCRamirez Jesus Nicolas · Miami, FLBuilt 1975 · S/N 28-7525137 N140NDCoco Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841206 N140NLN140nl LLC · Maumelle, ARBuilt 1966 · S/N CE-27 N140PCNavigation Leasing LLC · Castle Rock, COBuilt 1976 · S/N 17268241 N140PLBennett Daniel C · Atlantic Beach, FLBuilt 1973 · S/N 28-7325663 N140RBKessler Nicholas · Central Point, ORBuilt 1979 · S/N 310R1807 N140RDAlpha Whiskey 3 LLC · Brandon, MSBuilt 1975 · S/N 31-7552051 N140SGta Air Inc · Addison, TXBuilt 1980 · S/N TH-1155 N140SBSkyfusion II LLC · Atlanta, GABuilt 1969 · S/N 28-25681 N140SDG5 Services LLC · Myrtle Beach, SCS/N 28-22963 N140SHThomas Raymond · Daytona Beach, FLBuilt 1967 · S/N 28-22668 N140SNRomey Shelley · Newnan, GABuilt 1965 · S/N 28-21153 N140UCJackson Donald R · Lexington Park, MDBuilt 1951 · S/N D-2822 N140WLMorning Air LLC · Indian Rocks Beach, FLBuilt 1979 · S/N TC-2231 N140WMBlue Wings LLC · Rossville, TNBuilt 1972 · S/N 28-7305052 N140ZGitomirski Michael L · Moseley, VABuilt 1965 · S/N 28-20617 N1410DMahaffey James P · Grand Prairie, TXBuilt 1951 · S/N 19993 N1410MRapp Steven W · Boulder City, NVBuilt 1971 · S/N 18260580 N1410TWelch Bruce E · Boyce, VABuilt 1972 · S/N 28R-7235281 N1410URuffcorn Aviation Co · Bettondorf, IABuilt 1982 · S/N 21064693 N1410YMolohan Ronald M · Elk Grove, CABuilt 1961 · S/N 17249110 N1411FKrause Alex D II · Clintonville, WIBuilt 1966 · S/N 17254906 N1411TCable Marsha A · Toronto, OHBuilt 1972 · S/N 28R-7235282 N1411UOxley Kevin L · Huntington, INBuilt 1976 · S/N 17267080 N1411XMaarouf Dan H · Seabrook, TXBuilt 1975 · S/N 34-7570239 N1412DKing Matthew W · Wilmington, NCBuilt 1951 · S/N 19995 N1412GBruch Lance J · Emmetsburg, IABuilt 1961 · S/N D-6895 N1412HAsherbranner Charles E · Yucaipa, CAS/N 28R-7737003 N1412MLes Ailes Libres Inc Trustee · Wilmington, DEBuilt 1988 · S/N 24-1639 N1412SJ&J Aviation LLC · Thedford, NEBuilt 1976 · S/N 18264971 N14133C I Holdings Ltd Inc · Lewes, DES/N 27-4701 N14135Olympiakh LLC · Louisville, KYBuilt 1971 · S/N 27-4702 N14138Island Bound LLC · Dunedin, FLS/N 27-4704 N1413FWitmer Brendle D · Woodbury, PABuilt 1966 · S/N 17254908 N1413SAgillaire Inc · Colleyville, TXS/N 18264972

Back to AD 98-21-21 R1