Registered aircraft · 3,961

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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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.

N421WNContractors Flight Service LLC · La Jolla, CABuilt 1976 · S/N 421C0100 N421WPMach 1 LLC · Rogers, ARS/N 421C0417 N421WSGandy John B · Conroe, TXBuilt 1977 · S/N 421C0433 N421WTWest One Holdings Inc · Cheyenne, WYBuilt 1978 · S/N 421C0620 N421WXCeaco Inc · Las Vegas, NVS/N 421B0262 N421XLLocaero Services Inc Trustee · Wilmington, DEBuilt 1979 · S/N 421C0803 N421XTAdam & Anya Holdings LLC · Wichita, KSBuilt 1978 · S/N 421C0447 N421XXLong William David · San Antonio, TXBuilt 1976 · S/N 421C0238 N421YBBotsis Aircraft Limited Inc · Chesterland, OHS/N 421C1212 N421YPWateractive43 LLC · Auburn, CAS/N 421B0511 N421YWTrl Aviation LLC · Little Rock, ARBuilt 1984 · S/N 421C1402 N421YYVsa Leasing LLC · Linden, MIBuilt 1980 · S/N 421C0872 N421ZSale Reported · Glen Allen, VASale reportedBuilt 1968 · S/N 421-0077 N421ZM3tr Aviation LLC · Longview, TXBuilt 1981 · S/N 421C1058 N421ZXBurmingham Don Trustee · Duarte, CAS/N 421C0304 N421ZZ421zz LLC · Wilmington, DES/N 421C1220 N4228CBurhmann Joel David · Justin, TXBuilt 1974 · S/N 414-0528 N422CMAerostar Aviation LLC · Tucson, AZBuilt 1981 · S/N 421C1046 N422DBurton Rick · Vancouver, WABuilt 1982 · S/N 421C1202 N422GMMidocin LLC · Southfield, MIBuilt 1976 · S/N 421C0055 N422PJCra Aviation LLC · Dickerson, MDBuilt 1981 · S/N 421C-1038 N4235CColville LLC · Signal Mountain, TNBuilt 1974 · S/N 414-0534 N4237CBreakaway Group Aviation LLC · Franklin, TNBuilt 1974 · S/N 414-0535 N423RBAdams Aviation Services Inc Owner Trustee · Wilmington, DEBuilt 1981 · S/N 340A1270 N423TMJp Aviation Leasing LLC · Salt Lake City, UTBuilt 1976 · S/N 421C-0107 N424JAJzj Air LLC · Wilmer, ALS/N 421C0885 N424MEKfl LLC · Canyon Country, CABuilt 1976 · S/N 340A0051 N424PCMontana Livestock Ag Credit Inc · Helena, MTS/N 340A1266 N4251TJett Shelby Kerman · Pewee Valley, KYFirst renewal noticeS/N 421B0533 N4258CSonrise Aviation LLC · Portland, INBuilt 1978 · S/N 310R1386 N425RGUpstate Aircraft LLC · Old Forge, NYS/N 340A0976 N4264CMmc Properties LLC · Cottonwood, AZBuilt 1978 · S/N 340A0516 N4264JBellamy Mark A · Freeville, NYBuilt 1975 · S/N 310R0201 N426LJVenture Air Solutions Inc · Opa Locka, FLBuilt 1981 · S/N 402C0434 N4272CKamps Air LLC · Grand Rapids, MIBuilt 1982 · S/N 414A0849 N42776Hap'S Air Inc · Ames, IABuilt 1973 · S/N 421B0394 N427CAChippewa Aerospace Inc · Gainesville, FLBuilt 1976 · S/N 310R0653 N427CCBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 1977 · S/N 421C0348 N427JMPittman James L · Destin, FLS/N 421C0103 N4287AWilliam Dolson And Associates LLC · Santa Fe, NMBuilt 1980 · S/N 340A1010 N428DLGiair LLC · Morristown, TNBuilt 1976 · S/N 310R0657 N429GMResendiz Marcelino · Alamo, TXBuilt 1982 · S/N 421C1251 N429RCN429rc LLC · Gladwyne, PABuilt 1979 · S/N 414A0243 N42AAN42aa LLC · Nantucket, MABuilt 1979 · S/N 402C0238 N42BCRotary Components International Inc · Houston, TXBuilt 1975 · S/N 421B0922 N42BJRegistration Pending · Oakland Park, FLRegistration pending, pending cancellationBuilt 1972 · S/N 421B0342 N42HMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 421C0683 N42MGSouth Aero Inc · Albuquerque, NMS/N 402C0320 N42MLRegistered aircraftS/N 421C0639 N42MWWalker Winston W Trustee · Tucson, AZBuilt 1981 · S/N 414A0680

Back to AD 87-21-02 R1