Registered aircraft · 1,915

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-22-01-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-22-01-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-22-01-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-22-01-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-22-01-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-22-01-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.

N877RCPlg Aviation LLC · Tucson, AZBuilt 1981 · S/N BB-978 N878KWehco Newspapers Inc · Little Rock, ARBuilt 1998 · S/N LJ-1513 N87CFFeltus Aviation LLC · Little Rock, ARBuilt 1983 · S/N BB-1122 N87CHTld LLC · Pasco, WABuilt 1972 · S/N LW-20 N87EDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-05 N87FPMillman Transportation LLC · Saint Louis, MOBuilt 1997 · S/N BB-1565 N87HBSierra Alpha Logistics LLC · Fort Lauderdale, FLBuilt 1990 · S/N LJ-1251 N87NWAlbatross Air Inc · Beaver, WVBuilt 1978 · S/N BE-42 N87QDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-60 N87SALiberty Air LLC · Christiansted, VIFirst renewal noticeBuilt 1982 · S/N BB-1089 N87VDynamic Avlease Inc · Bridgewater, VAS/N LM-130 N880DTOklahoma Department Of Transportation · Oklahoma City, OKBuilt 1991 · S/N LJ-1288 N880MBWabash Wings LLC · Fishers, INBuilt 1981 · S/N BB-928 N881MCFoothills Aviation Partners LLC · Winston Salem, NCS/N BB-1930 N882JPJpb Air LLC · Rancho Santa Fe, CABuilt 1981 · S/N BB-882 N886AWAndrew & Williamson Sales Co · San Diego, CABuilt 1986 · S/N FA110 N8887BSt Croix Acceptance Corp · Devils Lake, NDBuilt 1987 · S/N LJ-1148 N888ASStanislaus Food Products Co · Modesto, CABuilt 1987 · S/N FA-136 N888EKExcalibur Knight One LLC · Miami, FLBuilt 1967 · S/N LC-263 N888JTNyerges James · Midland, TXFirst renewal noticeBuilt 1966 · S/N LP-21 N888MPProbasco Mitch · Floydada, TXBuilt 1990 · S/N BB-1358 N888ZTRev Aircraft LLC · Wilmington, DEBuilt 1978 · S/N LW315 N888ZXEm Air LLC · Richland, WABuilt 1983 · S/N BB-1140 N88FARegistration Pending · Helena, MTRegistration pendingBuilt 1979 · S/N BE-74 N88GLWichita State University · Wichita, KSBuilt 1981 · S/N LJ-945 N88HMFinch Air LLC · Midland, TXBuilt 1970 · S/N LJ-502 N88JHTeton Aviation Limited Liability Company · Wilson, WYBuilt 1989 · S/N BB-1331 N88MYBullrock Corp · South Burlington, VTBuilt 1983 · S/N BB-1142 N88VNAt Aero LLC · Wilmington, DEBuilt 1986 · S/N BB-1250 N88WAWiseman Aviation Inc · Flagstaff, AZBuilt 1983 · S/N LJ-1057 N88XJN88xj LLC · Park Ridge, ILBuilt 1998 · S/N LJ-1525 N890NCDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N LJ-893 N890VPDodson International Parts Inc · Rantoul, KSS/N BB-1116 N891AAAugusta Aviation Inc · Augusta, GAFirst renewal noticeBuilt 1989 · S/N LJ-1221 N898BRElite Medical Air Transport LLC DBA · El Paso, TXBuilt 1986 · S/N BB-1255 N899BAReliance Air LLC · Conway, ARBuilt 1993 · S/N LJ-1344 N899CAAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U-104 N899CZN899cz LLC · Milwaukee, WIS/N U-96 N899DCentral Virginia Aviation Inc · Petersburg, VABuilt 1968 · S/N LJ-386 N89FDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1969 · S/N LM-124 N89JLDag Aviation Inc Trustee · Wilmington, DEBuilt 1980 · S/N LA19 N89UABoard Of Trustees · Fayetteville, ARBuilt 1989 · S/N BB-1336 N8FHIron Sky Capital LLC · Lubbock, TXBuilt 1997 · S/N LJ-1477 N8GUAugusta Aviation Inc · Hilton Head Island, SCBuilt 1985 · S/N LJ-1103 N8NAN8na LLC · Atlantic Beach, FLBuilt 1981 · S/N BB-950 N900ACTurbo Air Charter LLC · Boise, IDBuilt 1978 · S/N LW282 N900BPColumbus State Community College · Columbus, OHBuilt 1965 · S/N LJ-61 N900CTRoughneck Supply LLC · Muskogee, OKBuilt 1995 · S/N LJ-1398 N900DZCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1974 · S/N LJ-618 N900MTLincoln Ventures LLC · North Highlands, CABuilt 1983 · S/N LJ1048

Back to AD 87-22-01 R1