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.

N949REAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1981 · S/N BB-949 N94CDSteel Clad Inc · Greenville, SCBuilt 1980 · S/N LJ-939 N94HBVms Aviation Services LLC · Ardmore, OKBuilt 1980 · S/N LJ-904 N94NDynamic Avlease Inc · Bridgewater, VAS/N LU-04 N94PGM Wall Inc · Chesapeake, VAFirst renewal noticeBuilt 1983 · S/N LA-205 N94SDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1971 · S/N LM-133 N950AAAlpine Aviation Inc · Provo, UTBuilt 1974 · S/N U-159 N950MBLos Angeles County Sheriffs Department · Long Beach, CABuilt 1990 · S/N BB-1372 N953AJS A Comunale Co Inc · Barberton, OHBuilt 2000 · S/N BB-1723 N953RCRmc Aviation LLC · Trumann, ARBuilt 1980 · S/N BE-94 N9546QNasair Aviation Services LLC · West Long Branch, NJBuilt 1966 · S/N LC-231 N954GSGlen Sain LLC · Paragould, ARBuilt 1997 · S/N LJ-1484 N954MSBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N BB-1649 N954ZAZulu Air LLC · Opa Locka, FLBuilt 2000 · S/N BB-1712 N957CBBd Air LLC · Battle Ground, WABuilt 1998 · S/N BB-1624 N958JHAims Community College · Greeley, COS/N LJ-1108 N958TPT&K Aviation LLC · Carrizo Springs, TXBuilt 1988 · S/N FA-172 N95GADrco Aviation LLC · Matthews, MOBuilt 1993 · S/N BB1467 N95LBTate James D · Christiansted, VIS/N LW-24 N95LMT L Irrigation Co · Hastings, NES/N BB-1956 N95PCCapcitcur Properties LLC · Youngsville, NCS/N LJ-1109 N95SDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1971 · S/N LM-125 N95TTKelly Air LLC · Cedar Falls, IABuilt 1981 · S/N BB-917 N95UTPacificorp · Portland, ORBuilt 2001 · S/N BB-1759 N960JPElite Medical Air Transport LLC DBA · El Paso, TXBuilt 1983 · S/N BB-1163 N963KAMeshoppen Air LLC · Tunkhannock, PABuilt 1977 · S/N LW242 N964GBTango Papa Whiskey LLC · Manchester Center, VTBuilt 1981 · S/N LJ-1007 N965LGGoody Birds LLC · Prattville, ALBuilt 1976 · S/N LW-204 N968DBJustair LLC · Elkhorn, NEBuilt 1988 · S/N LJ-1172 N96AGSouthern Star Aviation LLC · Missoula, MTBuilt 1967 · S/N LJ-260 N96AMTexas A&M University System · College Station, TXBuilt 2000 · S/N BB-1713 N96AVUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-201 N96CESummit Air Leasing LLC · Portage, MIBuilt 1996 · S/N BB-1536 N96JEAir Jody LLC · Riviera Beach, FLS/N LJ-1677 N96KKPro Serve Aviation LLC · Englewood, COBuilt 1980 · S/N LA104 N96SDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1970 · S/N LU-13 N96TTTelcom Rentals LLC · Lake Charles, LAFirst renewal noticeBuilt 1980 · S/N LA-26 N96WCUp And Down Aviation LLC · Carrollton, TXBuilt 1981 · S/N BB-969 N96YDynamic Avlease Inc · Bridgewater, VABuilt 1970 · S/N LU-8 N970EATailwind Investments LLC · Anchorage, AKS/N UC-100 N970JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N LJ-1650 N971AMHoefler Wayne F · Colorado Springs, COBuilt 1981 · S/N LJ-983 N971SCAxis Transportation Services LLC · Sacramento, CABuilt 1993 · S/N LJ-1343 N973GACentral Virigina Aviation Inc · North Dinwiddie, VABuilt 1975 · S/N LJ675 N973JHJdh-Im King Air LLC · Brownwood, TXS/N BB-1953 N973KSKlotz Aviation LLC · Holcomb, KSS/N FA107 N975SPSky Power LLC · Albuquerque, NMBuilt 1977 · S/N LW-263 N976RCSpirit Enterprises LLC · Greenwood, MSBuilt 1988 · S/N FA-141 N977AAGuardian Flight Holdings Inc · Fairbanks, AKBuilt 1972 · S/N LJ-555 N979DKCatia Resources LLC · Garden City, TXBuilt 1985 · S/N FA-79

Back to AD 87-22-01 R1