AD 2000-22-18

Registered aircraft · 914

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
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:2000-22-18')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-22-18')
  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.

N4619MNfv LLC · Helena, MTBuilt 1978 · S/N TH-918N461BCB&K Leasing Inc · Nantucket, MABuilt 1992 · S/N TH-1661N4621MBassline Logistics LLC · Watauga, TNS/N TH-919N463KBBuster Air LLC · Miami, FLBuilt 1972 · S/N TH-278N4657ATessos Air Service Inc · Wilmington, DES/N TH-41N468PN Fl Servicing LLC · Santa Rosa Beach, FLBuilt 2000 · S/N TH-1965N46DMEdwards John Guerrant · Stoneville, NCBuilt 1979 · S/N TH-1048N46HW2j2g LLC · Wilmington, DES/N TH-2119N4733MNelson Steven L · Hampton, MNBuilt 1978 · S/N TH-927N476EWWny Air Inc · Dover, DEBuilt 1996 · S/N TH-1797N47GAJcb Air LLC · Southport, NCBuilt 1975 · S/N TH-547N48CCC Baron LLC · Lafayette, LAFirst renewal noticeBuilt 1981 · S/N TH-1277N48JClever Conceptz LLC · Danbury, CTS/N TH-409N48TXCulater LLC · Indianapolis, INBuilt 1985 · S/N TH-1493N498CPConstruction Design Management LLC · Bowling Green, KYS/N TH-703N49DCenturian 94n LLC · Ripon, CABuilt 1974 · S/N TH-542N4HESouth Florida Aerobatics LLC · West Palm Beach, FLBuilt 1976 · S/N TH-787N4JADiamond Aviation LLC · Tuscaloosa, ALBuilt 1994 · S/N TH-1714N4LWWilliams Jason Allen · Cypress, TXBuilt 1992 · S/N TH-1652N4WZMulligan Peter · Richardson, TXBuilt 1970 · S/N TH117N500BAKw Plastics · Troy, ALBuilt 1997 · S/N TH-1814N500LDJ & H Investment Corp Inc · Columbia, MOBuilt 1979 · S/N TH-1008N500TLSententia LLC · Highland Park, ILBuilt 1999 · S/N TH-1890N501MLVotava Paul A · Mcintosh, MNBuilt 1970 · S/N TH-72N503BAP&B Aviation Corp · Wilmington, DES/N TH-862N504TBAutomotive Air III LLC · Belcamp, MDBuilt 1997 · S/N TH-1810N5065RZ J Express LLC · Lewes, DEBuilt 2002 · S/N TH-2040N5096RProvestment International LLC · West Melbourne, FLBuilt 2001 · S/N TH-1996N509PTailwindsbikelyft LLC · Hannibal, MOBuilt 2000 · S/N TH-1947N50SSAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2000 · S/N TH-1961N511CFFendler Michael J · Pittsfield, MEBuilt 1977 · S/N TH-833N511DFKma Aviation LLC · Phoenix, AZBuilt 1980 · S/N TH-1175N515RGDowney Paul J · Newington, NHS/N TH-2108N517MRDgw Aviation LLC · Elverson, PAS/N TH-2012N51FDH2f2 LLC · Prairie Village, KSBuilt 1979 · S/N TH-1075N51MTTrantham Joey L · Panama City, FLBuilt 1985 · S/N TH-1485N520LLMesoamerica Aviation Corp · Wilmington, DEBuilt 2002 · S/N TH-2052N521WSCmt Properties LLC · Laurel, MSBuilt 1997 · S/N TH-1836N524CBTechnical Film Systems Inc · Camarillo, CABuilt 1991 · S/N TH-1630N524RTN524rt LLC · Greensboro, NCBuilt 1970 · S/N TH-123N525TMVertivue LLC · Allentown, PABuilt 1997 · S/N TH-1832N526BDLoeffelholz John W · Fort Worth, TXBuilt 1984 · S/N TH-1436N527BHRed River Cellular Telephone Corp · Paris, TXBuilt 1980 · S/N TH-1190N527TAPlane Leasing LLC · Wilmington, DEBuilt 1973 · S/N TH-290N531KCConstantine LLC · Fort Collins, COBuilt 1985 · S/N TH-1484N537SWBingham Leasing Co Lc · Mesa, AZBuilt 1991 · S/N TH-1619N53RTCas Capital Holdings LLC · Newark, DES/N TH-2113N541JESimpson Kendal · Port Orange, FLBuilt 1975 · S/N TH-577N543RBBaron Aviation LLC · Calera, ALBuilt 2000 · S/N TH-1953N549PTGrant P T · Musella, GABuilt 1976 · S/N TH-711
Back to AD 2000-22-18