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.

N90MURwc Aircraft Sales LLC · Gillespie, ILBuilt 1976 · S/N LJ-679 N90NCDodson International Parts Inc · Rantoul, KSBuilt 1968 · S/N LJ342 N90PHTriple R Spraying LLC · Dumas, TXBuilt 1973 · S/N LW-60 N90PRSfclh LLC · Yukon, OKBuilt 1996 · S/N LJ-1437 N90RTFlavin Development LLC · Lake Charles, LABuilt 1981 · S/N LA-146 N90SBDavidson Logistics Inc · Bridgeton, MOBuilt 1981 · S/N LA-154 N90TDMike Russell Construction Inc · Marysville, CABuilt 1982 · S/N LA-183 N90TJTalcorp Ec Inc · Justin, TXS/N LW-228 N90TPFairview Air LLC · Fresno, CABuilt 1980 · S/N LA-66 N90UAUniversal Avionics Systems Corp · Tucson, AZBuilt 1980 · S/N LA-21 N90WFRegistration Pending · Midland, TXRegistration pendingBuilt 1988 · S/N FA-164 N90WJDodson International Parts Inc · Rantoul, KSBuilt 1971 · S/N LJ-525 N90WLUniversity Of Maryland Eastern Shore · Princess Anne, MDBuilt 1969 · S/N LJ-461 N910AJL'Eagle Air II Inc · Newark, DEBuilt 1981 · S/N BB-910 N910EHGuardian Flight LLC · Lewisville, TXBuilt 2005 · S/N LJ-1751 N910KGLg Air LLC · Baton Rouge, LABuilt 1983 · S/N BB1051 N911CFCustom Flight Rnh LLC · New Richmond, WIBuilt 1979 · S/N LA-13 N911CMPhi Health LLC · Tempe, AZBuilt 1996 · S/N BB-1551 N911CXCentral Virginia Aviation Inc · Petersburg, VAFirst renewal noticeBuilt 1979 · S/N LJ-830 N911FNApollo Aviation LLC · Las Vegas, NVBuilt 1976 · S/N LJ-688 N911KADavis Aviation DBA · Brandon, MSS/N FA-44 N911PYOrchtrans Inc Trustee · Wilmington, DEBuilt 1960 · S/N LF-21 N911RLDale Aviation Inc · Rapid City, SDBuilt 1989 · S/N LJ-1219 N911RXReach Air Medical Services LLC · Santa Rosa, CABuilt 1992 · S/N BB-1425 N911SFReiner Russell · Redding, CABuilt 1999 · S/N BB-1659 N911ZCValiair Lc Trustee · Casper, WYS/N LJ-1557 N911ZEGilgal Stones Consulting LLC · Flint, TXS/N LJ-1358 N912MNAvera Mckennan · Sioux Falls, SDBuilt 1993 · S/N BB1468 N912SVSaint Vincents Healthcare · Billings, MTBuilt 1988 · S/N BB-1299 N913RXReach Air Medical Services LLC · Santa Rosa, CABuilt 1993 · S/N BB-1471 N914DKCal-Ore Life Flight LLC · Brookings, ORBuilt 1996 · S/N LJ-1445 N914JALake Area Technical College · Watertown, SDBuilt 1989 · S/N FA-191 N914SHSanford Medical Center · Sioux Falls, SDBuilt 1999 · S/N BB-1688 N915CDN915cd LLC · Woodland, CABuilt 1977 · S/N LJ748 N915MRGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N LJ-1637 N917WAN917wa Corp Trustee · Wilmington, DEBuilt 1985 · S/N FA-77 N918BBAlco Aviation Services Consulting LLC · Taft, TNBuilt 1980 · S/N LA113 N918CACalifornia Highway Patrol · Sacramento, CABuilt 1978 · S/N BC-57 N918DDDiamond D Aviation LLC · Sulphur, LABuilt 1999 · S/N BB-1677 N918MMVegetable Flight Resources LLC · Portland, ORBuilt 1980 · S/N LA-52 N918MRMarc Aircraft Holding LLC · Soldotna, AKS/N LM-138 N918MTIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 1983 · S/N LA-211 N918SAThiel Air Care Inc · Chowchilla, CABuilt 1980 · S/N LJ918 N918VSDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N LW-200 N919HPKing Three LLC · Forest Hill, MDBuilt 1985 · S/N FA-81 N91CTClemson University · Clemson, SCBuilt 1998 · S/N LJ-1521 N91KABank Of Utah Trustee · Salt Lake City, UTS/N LJ-1232 N91RWJujufa21 LLC · Wilmington, DEBuilt 1984 · S/N FA-21 N91SDynamic Avlease Inc · Bridgewater, VABuilt 1972 · S/N LU-15 N920TTBank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N LJ-1300

Back to AD 87-22-01 R1